topic Re: Switching Dimensions with $Field in QlikView

Switching Dimensions with $Field

Wed, 27 Aug 2014 10:14:05 GMT

Hi there,

I'm trying to get a chart Dimension to be variable based on a table selection. Because the various 'dimensions' can change or be added to frequently I want to avoid creating a 'conditional dimension' for every one, which is how I've done it in the past.

The image below shows how far I've got - but it isn't quite working. Any suggestions? I want it to look like the chart at the bottom, with the option of changing.

Thanks very much,

Re: Switching Dimensions with $Field

MK_QSL — Wed, 27 Aug 2014 10:23:33 GMT

Use Calculated Dimension

=$(=GetFieldSelections([$Field]))

Re: Switching Dimensions with $Field

simondachstr — Wed, 27 Aug 2014 10:26:45 GMT

Try ='$($(='=Only($Field)'))' as dimension.

Re: Switching Dimensions with $Field

tresB — Wed, 27 Aug 2014 10:28:58 GMT

Or, simply =$(=[$Field]) // works when single value to be selected

For multiple selections you have to use a bit of tricks: all fields in the dimnesions with conditional enablement.

Re: Switching Dimensions with $Field

simondachstr — Wed, 27 Aug 2014 11:24:53 GMT

Good one! I guess I lost myself in scripting