Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

deepakindia99
New Contributor

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

Re: Set analysis for two conditions

May be this:

And condition

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

or

or condition

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

deepakindia99
New Contributor

Re: Set analysis for two conditions

Big Thanks! Sunny, The second condition works perfectly!

Regards

Deepak

Angela_Zhou
New Contributor

Re: Set analysis for two conditions

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 Zhou