how to select non-classified data (empty content)

[reinholdgraf]

Hi.

We have classified our Articles in A,B,C,D-Types.

Currently, there are still some articles not classified (empty content).

Showing Data in Visualisations using the ABCD-Field as dimension is ok, because the share of non-classified articles is shown as grey bar.

But I need to select this share in another visualisation together with some other filters in set-analysis.

I tried to use the exclude-function as shown below, but this isn't working.

[Ref_ABCD]=E({1<[Ref_ABCD]={'A','B','C','D'}>})

Any idea to get this addressed ?

Reinhold

[sunny_talwar]

May be create a flag in the script

LOAD Ref_ABCD,

          If(Match(Ref_ABCD, 'A', 'B', 'C', 'D'), 1, 0) as Ref_ABCD_Flag

          ....

FROM/Resident ....;

and then just this

{<Ref_ABCD_Flag = {0}>}

[Anil_Babu_Samineni]

May be try front end by help of this, But it should happen with selectors only

sum({$<[Ref_ABCD] = E([Ref_ABCD])>} Measure)

[reinholdgraf]

working - thanks

[reinholdgraf]

@Anil Babu Samineni

this isn't working. most likely because the E-Function can only exclude existing values...

[sfatoux72]

Hi,

Your idea ([Ref_ABCD]=E({1<[Ref_ABCD]={'A','B','C','D'}>}))  was good but not 100% correct.

You need simply used a field that as a value when Ref_ABCD is null like Article for example :

Article = E({1<Ref_ABCD={'A','B','C','D'}>})