topic How to do in single IF Statement in QlikView

How to do in single IF Statement

Fri, 24 Dec 2010 07:48:23 GMT

Dear All,

How do we can mention the below condition in a single IF statement like:

=Count( if (Customer <> ('A','B','C','D','E','F','G'),Test1,Test2))

Is there any other alternative ?

sunil2288 — Fri, 24 Dec 2010 08:00:30 GMT

Hi Kumar ,

You can use set analysis to solve this.

IF(CUSTOMER-={'A','B','C','D'..},COUNT(TEST1),COUNT(TEST2))

Try this....

Thanks

Sunil

Fri, 24 Dec 2010 08:11:20 GMT

is there any other option to mention more than one item for a perticular variable like

customer NOT in ('A','B','C',........)

colinh — Fri, 24 Dec 2010 08:37:58 GMT

Try count(if (match(Customer, 'A', 'B', 'C', 'D', 'E', 'F', 'G') = 0, Test1, Test2))

sunil2288 — Fri, 24 Dec 2010 09:46:55 GMT

Hi Kumar,

Yes for that purpose only Set Analysis came in to existance.

You can do it Like

Count({$<Customer-={'A','B','C',...}>}Test1)

for writing NOT use -=(Minus and equal to combinely)

Regards

Sunil