Excluding values in SET-Analysis

[reinholdgraf]

Hi.

We have classified our articles into A,B,C etc.

I now want to show the articles not classified, but all other selections (Division, Year, etc.) must still work.

I tried it like this:

sum({$-<[Ref_ABCD]={'A','B','C','D'}>}[LB_W_AJ_$(v_BerichtsWaehrung)])

Calculated Value is correct, but in the chart, the x-axis (Year-Month) is gone; only 1 value is displayed.

Regards,

Reinhold

[brunobertels · Accepted solution]

Hi

Try this :

sum({$<[Ref_ABCD]-={'A','B','C','D'}>}[LB_W_AJ_$(v_BerichtsWaehrung)])

Minus sign before = sign

[MK_QSL]

sum({$<[Ref_ABCD] -={'A','B','C','D'}>}[LB_W_AJ_$(v_BerichtsWaehrung)])

or

sum({$<[Ref_ABCD]={'*'}-{'A','B','C','D'}>}[LB_W_AJ_$(v_BerichtsWaehrung)])

[reinholdgraf]

ok. working.

How can I now add the articles with no-value in this field (Ref_ABCD) ?

[MK_QSL]

You mean Null Values?

[reinholdgraf]

yes

[brunobertels]

Hi

May be this

sum({$<[Ref_ABCD]={'*',""}-{'A','B','C','D'}>}[LB_W_AJ_$(v_BerichtsWaehrung)])

But the Best would be to affect a value to null cells

https://community.qlik.com/docs/DOC-3155

[reinholdgraf]

I agree.

I now check NullValue in the Load-Script and assign a value such as 'n.n.', what can easily be used as a filter in SET-Analysis.

Thx!