topic Re: LOGICAL OR in QLIKVIEW in QlikView

LOGICAL OR in QLIKVIEW

Mon, 03 Jun 2013 18:23:35 GMT

I have the following Scenario.

USER_ID, FIELD-A, FIELD-B, FIELD-C, FIELD-D

I am trying to count USER_ID if any of the FIELDS-A to FIELD-D has more than 0.

How do I count?

Thank you

Gysbert_Wassenaar — Mon, 03 Jun 2013 18:36:46 GMT

count({<[FIELD-A]={'>0'}>+<[FIELD-B]={'>0'}>+<[FIELD-C]={'>0'}+<[FIELD-D]={'>0'} USER_ID)

er_mohit — Mon, 03 Jun 2013 18:40:03 GMT

Try this

load

USER_ID, FIELD-A, FIELD-B, FIELD-C, FIELD-D

from table;

No Concatenate

load

count(if(FIELD-A>0 and FIELD-B>0 and FIELD-C>0 and FIELD-D>0,USER_ID)) as User_Count,

USER_ID, FIELD-A, FIELD-B, FIELD-C, FIELD-D

resident A;

Group by USER_ID, FIELD-A, FIELD-B, FIELD-C, FIELD-D;

drop table A;