Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable


vYear which hold values on the basis of year selection by user like 10,11,12,13,14,15,16...from list box

vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7 are variable which holds different values.

requirment is like if vYear=10 then vValue1 ,if vYear=11 then vValue2 ,if VYear=12 the vValue3

I tried with pick, Pick(vYear,vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7)

but did not work , any other way to do it.

1 Reply

Re: Expression

Try vYear - 9:

pick(vYear - 9,vValue1,vValue2,...)

Community Browser