Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis for two conditions

Hi team,

Need one help with respect to Set analysis

In My expression i have a set analysis string  =Sum({<BU2-={'Total'}>}comparision_AR)

I want to merge another =Sum({<BURGN-={'Total'}>}comparision_AR)

could you pls help how to merge this two string and put it in a single?

Thanks in advance

Deepak

3 Replies
sunny_talwar

May be this:

And condition

=Sum({<BU2-={'Total'}, BURGN-={'Total'}>}comparision_AR)

or

or condition

=Sum({<BU2-={'Total'}>+<BURGN-={'Total'}>}comparision_AR)

Anonymous
Not applicable
Author

Big Thanks! Sunny, The second condition works perfectly!

Regards

Deepak

Angela_Zhou
Contributor III
Contributor III

And condition can also using the binary operation (*), which is very usefully especially when you need mix conditions of AND, OR, and etc.

=Sum({<BU2-={'Total'}>*<BURGN-={'Total'}>} comparision_AR)

Angela Z.