Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
yanivvl0
Contributor III

How to change field in dynamic dimension according to select field value?

hi to all , i have  a chart , in it there is a year dimension ( and an expression ) , in the model there is another status field , and 4 year fields,

i need in the (calculate) year dimension  - for every single selected value in the status field to use a different year field ,

for example  : if i select status = 210 , then the dimension need to be year_fld_1 ,

if i select status = 211 , then the dimension need to be year_fld_2   ....

is there any way to do so ?   THANKS .

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How to change field in dynamic dimension according to select field value?

Maybe with something like this:

pick(match(Status, 210,211,...), year_fld_1, year_fld_2, ...)

- Marcus

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to change field in dynamic dimension according to select field value?

Maybe with something like this:

pick(match(Status, 210,211,...), year_fld_1, year_fld_2, ...)

- Marcus

View solution in original post

yanivvl0
Contributor III

Re: How to change field in dynamic dimension according to select field value?

thanks M arcus !!