topic Re: How to use OR operator in Set Analysis in QlikView

How to use OR operator in Set Analysis

divianjani — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I need urgent help...

i have an expression by using IF condition along with And OR operators..

Now i want to write same expression by using set analysis without using IF condition...

Original Exp:

sum(if((match(Coulmn1,01,02,03,04,05,06) and Column2 = 'Dis' or Column2 = 'Com')

and match(Column3,7,8) and OG <> ' ' and TSIT = 'Sales',Units))

So i have tried by using set analysis like below.

sum({<Coulmn1={'01','02','03','04','05','06'}, Column2 = {'Dis','Com'},Column3={7,8},OG-={' '},TSTI ={'Sales'}>} Units )

So, when i have applied this in the report values are not matching with earlier one, Can any one help me out...

Thanks in Advance

sunny_talwar — Fri, 07 Sep 2018 10:50:01 GMT

Are you sure this is the correct original expression?

sum(if((match(Coulmn1,01,02,03,04,05,06) and Column2 = 'Dis' or Column2 = 'Com')

and match(Column3,7,8) and OG <> ' ' and TSIT = 'Sales',Units))

May be you want this

sum(if((match(Coulmn1,01,02,03,04,05,06) and (Column2 = 'Dis' or Column2 = 'Com'))

and match(Column3,7,8) and OG <> ' ' and TSIT = 'Sales',Units))

Because if your original expression was correct, then the set analysis will probably need to change because it is saying

Condition 1 is true

match(Coulmn1,01,02,03,04,05,06) and Column2 = 'Dis'

Condition 2 is true

Column2 = 'Com'

Is that what it really is?

sunny_talwar — Fri, 07 Sep 2018 10:56:36 GMT

You can try this, if your original expression is right

Sum({<Coulmn1 = {'01','02','03','04','05','06'}, Column2 = {'Dis'}, Column3 = {7,8}, OG -= {' '}, TSTI = {'Sales'}>+

<Column2 = {'Com'}, Column3 = {7,8}, OG -= {' '}, TSTI = {'Sales'}>} Units)

divianjani — Fri, 07 Sep 2018 11:02:15 GMT

Thanks for your response sunny..

Yes that is original expression...

i will try with above one.

divianjani — Fri, 07 Sep 2018 11:15:39 GMT

Thank you so much sunny

It is working fine values are matching....