Set Analysis - multiple conditions on the same variable

Wed, 30 Mar 2011 11:33:26 GMT

Hello Everyone,

I have the following statement currently:

=COUNT({<NON_COMPANY={'Other'}, NO_COMPANY_KEYWORD=>} UID)

I have the

NO_COMPANY_KEYWORD=

because I want the chart to act independently of the listbox, however I also want to do put in a condition that says 'exclude all that are null' which I would normally do as the following:

NO_COMPANY_KEYWORD-={''}

, however I'm not sure how to combine these two. Is it possible without explicitly listing my keywords?

Thanks

Gareth

Set Analysis - multiple conditions on the same variable

Miguel_Angel_Baeyens — Wed, 30 Mar 2011 12:06:25 GMT

Hello Gareth,

Try the following

=COUNT({<NON_COMPANY={'Other'}, NO_COMPANY_KEYWORD=> - < NO_COMPANY_KEYWORD -= P(NO_COMPANY_KEYWORD ) >} UID)

Hope that helps

topic Set Analysis - multiple conditions on the same variable in QlikView

Set Analysis - multiple conditions on the same variable

Set Analysis - multiple conditions on the same variable