topic Conditional Dimension in QlikView

Conditional Dimension

Wed, 04 Jun 2014 13:25:58 GMT

I have created a pivot chart with three dimensions.

On one of the dimensions, I would like for it not to show a certain value. If the value happens to be 'Other' then I don't want it to show up in my chart.

I have tried doing it under the enable condition for the selected dimension but it doesn't seem to work.

Any suggestions?????

Re: Conditional Dimension

jonathandienst — Wed, 04 Jun 2014 13:29:26 GMT

Use a calculated dimension:

=If(Dimension <> 'Other', Dimension)

=Aggr(Only(If(Dimension <> 'Other', Dimension)), Dimension)

Or use exclude it in the expressions:

=Sum({<Dimension -= {'Other'}, ......)

(where Dimension is the name of your dimension field)

HTH

Jonathan

Re: Conditional Dimension

jerem1234 — Wed, 04 Jun 2014 13:29:41 GMT

You will have to use a calculated dimension, something like:

If(FIELD <> 'Other', FIELD)

This way the values that have the value 'Other' will be mapped to null, and the rest stay as they are.

Hope this helps!

Re: Conditional Dimension

jonathandienst — Wed, 04 Jun 2014 13:31:19 GMT

Oh, and check the Suppress if null option for that dimension...