topic Re: Hide Dimension when a Cyclic Selection has been made in QlikView

Hide Dimension when a Cyclic Selection has been made

ivandrago — Fri, 15 Aug 2014 16:57:21 GMT

Hi,

Is it possible to hide a Dimension from a Chart based on which Dimension is selected from a Cyclic?

So if you look at the attached I want

Hide the Dimension "Desc" when the Dimension "DimA" is selected from the Cyclic

Thanks

Marcio_Campestrini — Fri, 15 Aug 2014 17:00:12 GMT

Hi Ivan

Try to use something like this:

In the dimension tab, select the "Enable conditional" option and write:

=GetCurrentField(<Cyclic Name>) = 'Field name'

Fri, 15 Aug 2014 17:07:07 GMT

Hi,

Yes it is possible, you just go to dimension sheet and select "Desc" field, then check in Allow Condicional and tip this expression:

=GetCurrentFiel("Type/Dim")<>'DimA'

And thats all.

See attached qvw.