topic Set analysis question (include null except certain values) in QlikView

Set analysis question (include null except certain values)

Mon, 17 Apr 2017 14:42:20 GMT

What would be the correct set analysis format to select all values in a dimension including the null value except for one specific value?

I am trying count({<Reason={"*"}-{'Other'}>} but this is not selecting the rows where the Reason is null (blank).

Please help.

Anonymous — Mon, 17 Apr 2017 14:49:15 GMT

How about checking isnull() and update it to 0 if you need only count?? like If(Field=Null(),0,Field) as Field1

Mon, 17 Apr 2017 14:50:54 GMT

I can't update the field to zero as count is only one of the expression. The dimension is displayed as it's values in other tables.

el_aprendiz111 — Mon, 17 Apr 2017 15:07:35 GMT

Hi,

Dimension

count({<Reason-={'Null'}>}

script

if(len(Trim(Reason)=0,0,Reason) AS Reason_2

Anonymous — Mon, 17 Apr 2017 15:10:38 GMT

count({<Reason-={'Other'}>YourField)

swuehl — Mon, 17 Apr 2017 15:12:51 GMT

Have a look at

So it could look like

=count({<OtherField = e({<Reason={'Other'}>} ) >} OtherField)

Mon, 17 Apr 2017 15:27:19 GMT

This works like a charm!... thanks!!!