Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sujit_nath
Creator III
Creator III

Set expression with OR condition

I want to show the amount where product is either ‘a’ or category is ‘x’ . What would be the set expression for this.

sujit_nath_0-1621274677600.png

 

 

1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

You could use:

aggr(only({$<product={'a'}>+<category={'x'}>} ID), ID) for you ID dimension expression.

View solution in original post

1 Reply
GaryGiles
Specialist
Specialist

You could use:

aggr(only({$<product={'a'}>+<category={'x'}>} ID), ID) for you ID dimension expression.