Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

reinholdgraf
Contributor

Excluding values in SET-Analysis

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

1 Solution

Accepted Solutions
brunobertels
Valued Contributor

Re: Excluding values in SET-Analysis

Hi

Try this :

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

Minus sign before = sign


7 Replies
brunobertels
Valued Contributor

Re: Excluding values in SET-Analysis

Hi

Try this :

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

Minus sign before = sign


Re: Excluding values in SET-Analysis

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
Contributor

Re: Excluding values in SET-Analysis

ok. working.

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

Re: Excluding values in SET-Analysis

You mean Null Values?

reinholdgraf
Contributor

Re: Excluding values in SET-Analysis

yes

brunobertels
Valued Contributor

Re: Excluding values in SET-Analysis

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
Contributor

Re: Excluding values in SET-Analysis

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!