topic Re: Set analysis for two conditions in QlikView

Set analysis for two conditions

Anonymous — Wed, 26 Oct 2016 08:38:47 GMT

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

sunny_talwar — Wed, 26 Oct 2016 16:39:34 GMT

May be this:

And condition

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

or condition

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

Anonymous — Thu, 27 Oct 2016 08:21:38 GMT

Big Thanks! Sunny, The second condition works perfectly!

Regards

Deepak

Angela_Zhou — Sun, 07 Apr 2019 14:14:52 GMT

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)