Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analisys filter records

Hi! I have this data load in the app

id    field1    field2

1       v1       data1

1       v2       data2

1       v1       data1

1       v2       data2

I need, in set analysis, when field2 is value "data2" EXCLUDE the registers for id = 1

Thamks a lot! And sorry for my english!!!

1 Reply
Gysbert_Wassenaar

Not sure what you're trying to show. But try only({<id-={1},field2={'data2'}>}field2) as expression.

btw, the expression editor doesn't recognize -= as valid syntax and will show a red underlining indicating an error, but it is actually correct.


talk is cheap, supply exceeds demand