Use variable as part of Dimension name

Cyriltra — Mon, 30 May 2022 09:55:04 GMT

Hello,

i have a data source with several metrics named as followed:

WF Sales

LF Sales

LP Sales

WF inventory

LF inventory

LP inventory

etc.

I would like the user to be able to select the period (WF, LF or LP) and the chart will display the right metric.

I've already set up the variable vPeriod that stores the period selected by the user (from a listbox selection); it's working fine.

But i'm now blocking on how to use the variable in the expression: a basic expression would be =sum([WF Sales]), how do i transform it to use my variable (so WF,LF or LP can dynamically change according to user input) ?

Thank you

Re: Use variable as part of Dimension name

hic — Mon, 30 May 2022 10:34:52 GMT

sum([$(period) Sales])

Re: Use variable as part of Dimension name

Cyriltra — Mon, 30 May 2022 10:41:51 GMT

simple, elegant, thank you !

topic Re: Use variable as part of Dimension name in QlikView

Use variable as part of Dimension name

Re: Use variable as part of Dimension name

Re: Use variable as part of Dimension name