Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
Champion III
Champion III

Try vYear - 9:

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