I know this has been discussed multiple times, but I was wondering whether anything has changed in recent releases. Is there any way to force a Qlik set expression to evaluate row by row for a field-to-field comparison? I need to write a complex expression that compares multiple fields within a single record, and I have run into the known issue (or feature, by design 🙂 ) that set expressions evaluate across the full set of distinct values. Please see the image below. We resolved the issue by replacing part of the set expression with if statements. The comparison involves a number of fields, so I was wondering whether any new set modifiers are available that would force row-level comparison when comparing two fields within a record.
