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

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

yanivvl0 — Thu, 22 Mar 2018 07:22:14 GMT

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 .

marcus_sommer — Thu, 22 Mar 2018 11:06:04 GMT

Maybe with something like this:

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

- Marcus

yanivvl0 — Thu, 22 Mar 2018 12:14:32 GMT

thanks M arcus !!