Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

Set Analysis Expression

I'm doing something wrong with my set analysis expression, but not sure how to fix it.  Please help!

 

Sum({<[Org Symbol]={'1234'}, or {'5678'}>}[Budget Amount])

 

It works when I just do set analysis on one org symbol, like 1234.  But I need to do both org symbols 1234 & 5678, so my problem is with the "or" part.

 

Thanks!

1 Solution

Accepted Solutions
zzyjordan
Contributor II

Re: Set Analysis Expression

Hi,
Have you tried this?
Sum({<[Org Symbol]={'1234','5678'}>}[Budget Amount])

ZZ

View solution in original post

4 Replies
zzyjordan
Contributor II

Re: Set Analysis Expression

Hi,
Have you tried this?
Sum({<[Org Symbol]={'1234','5678'}>}[Budget Amount])

ZZ

View solution in original post

Partner
Partner

Re: Set Analysis Expression

Nope, I had not tried that, but this seemed to be the answer.  So the "or" is implied with the comma, yes?

zzyjordan
Contributor II

Re: Set Analysis Expression

yes and no.
Set analysis actual defines a set of data for the calculation, you can regard this is a subset of the original data set, and the calculation(sum, avg, etc.) only happens within the subset. so we can't say use comma to replace 'Or' as the values inside {} just defines the dataset where [Org Symbol] contains value inside the {}. hope this makes sense.

ZZ
Highlighted
Partner
Partner

Re: Set Analysis Expression

yes, that makes sense.  thank you so much!