topic Re: Logical operators in set analysis in QlikView

Logical operators in set analysis

Wed, 16 Oct 2013 12:36:30 GMT

Hi all,

Can anyone explain me how the logical operators takes place in set analysis for below expression :

Count({$<DS={"Fail","Pass"}, LR={"Fail","Pass"}>} Distinct Lenskey)

i.e; which of the condition are correct for above set analysis

1.) Select Count (Distinct Lenskey) From table where DS ='Fail' or DS='Pass' or LR='Fail' or LR='Pass'

2.) Select Count (Distinct Lenskey) From table where DS ='Fail' and DS='Pass' and LR='Fail' and LR='Pass'

3.) Select Count (Distinct Lenskey) From table where (DS ='Fail' or DS='Pass') and (LR='Fail' or LR='Pass')

Thanks in advance

Anonymous — Wed, 16 Oct 2013 12:52:10 GMT

Venkat

It is your:

3.) Select Count (Distinct Lenskey) From table where (DS ='Fail' or DS='Pass') and (LR='Fail' or LR='Pass')

As in this bit means either Fail OR Pass

{"Fail","Pass"}

and the comma in the middle seperate things as an AND

{$<DS={"Fail","Pass"}, LR={"Fail","Pass"}>} Distinct

Best Regards, Bill

jchoucq — Wed, 16 Oct 2013 12:54:53 GMT

i will say Option 3

Regards.

Johann

Wed, 16 Oct 2013 13:44:48 GMT

Thanks to all your suggestion.

Regards,

Venkat