What type of comparison does the Match function perform?

The Match function in Qlik Sense is designed to perform an exact match comparison but is also case insensitive by default. This means that when you use the Match function, it looks for exact values within a list, but it does not differentiate between upper and lower case letters. As a result, the Match function will consider 'Apple', 'apple', and 'APPLE' as equivalent.

This characteristic makes it particularly useful for scenarios where you want to ensure that different capitalizations of the same term should be treated as matches without requiring the user to standardize the casing of their input. Because the Match function is case insensitive, any selection or condition applied using it effectively broadens the potential matches, making user inputs more flexible. In contrast to options that might imply a focus on either wildcards or case sensitivity, the key feature of the Match function lies in its ability to identify exact, yet case-insensitive values within the given dataset.