topic Re: dimensions in chart in QlikView

dimensions in chart

Bubskim — Sun, 28 Jul 2019 17:48:44 GMT

Hi all,

Please help.

I need to add a dimension to my chart. Basically I have the used dimension of DL Name - this comes from the column name in my excel. I need to exclude certain DL's (distributions list) form displaying. How do I write an expression for that?

I am not the best in if or wild match I really need to exclude and or suppress specific DL's

Re: dimensions in chart

lockematthewp — Tue, 06 Aug 2019 19:55:51 GMT

You can do:

=if ([DL Name] <> 'whatever', [DL Name])

or if there are multiple:

=if (wildmatch([DL Name], 'whatever', 'orThis', 'orThat') = 0, [DL Name])

Re: dimensions in chart

Marcos_rv — Tue, 06 Aug 2019 20:25:15 GMT

but do you have an excel with the excluded? you could use an applimaps and mapping to build a flag, "if you must exclude it".

Regards!!!