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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

'OR' in Set Analysis

Hi All,

How would I incorporate an 'OR' in a set analysis?

Sum({<Group={'A'},Dept={'AB'}>} Sales) will give sum of sales of Group A AND Dept AB

I wishi to get the Sum of Group A OR Dept AB.

How will that be set?

Thanks

Josh

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

Try

=Sum({<Group={'A'}>+<Dept={'AB'}>} Sales)

View solution in original post

2 Replies
swuehl
Champion III
Champion III

Try

=Sum({<Group={'A'}>+<Dept={'AB'}>} Sales)

jduenyas
Specialist
Specialist
Author

You always come in for me!

Thanks a lot!