Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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}>}
May be try front end by help of this, But it should happen with selectors only
working - thanks
@Anil Babu Samineni
this isn't working. most likely because the E-Function can only exclude existing values...
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'}>})