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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

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

View solution in original post

2 Replies
swuehl
MVP
MVP

Try

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

jduenyas
Specialist
Specialist
Author

You always come in for me!

Thanks a lot!