Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression

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
johnw
MVP
MVP

Try vYear - 9:

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