Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jduenyas
Not applicable

'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

Tags (2)
1 Solution

Accepted Solutions
swuehl
Not applicable

'OR' in Set Analysis

Try

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

2 Replies
swuehl
Not applicable

'OR' in Set Analysis

Try

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

jduenyas
Not applicable

'OR' in Set Analysis

You always come in for me!

Thanks a lot!