Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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.