topic Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/1151621#M632911 <HTML><HEAD></HEAD><BODY><P>vYear which hold values on the basis of year selection by user like 10,11,12,13,14,15,16...from list box</P><P></P><P>vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7 are variable which holds different values.</P><P></P><P>requirment is like if vYear=10 then vValue1 ,if vYear=11 then vValue2 ,if VYear=12 the vValue3 </P><P></P><P>I tried with pick, Pick(vYear,vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7)</P><P></P><P>but did not work , any other way to do it.</P></BODY></HTML> Thu, 30 Jun 2016 18:02:06 GMT 2016-06-30T18:02:06Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1151621#M632911 <HTML><HEAD></HEAD><BODY><P>vYear which hold values on the basis of year selection by user like 10,11,12,13,14,15,16...from list box</P><P></P><P>vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7 are variable which holds different values.</P><P></P><P>requirment is like if vYear=10 then vValue1 ,if vYear=11 then vValue2 ,if VYear=12 the vValue3 </P><P></P><P>I tried with pick, Pick(vYear,vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7)</P><P></P><P>but did not work , any other way to do it.</P></BODY></HTML> Thu, 30 Jun 2016 18:02:06 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1151621#M632911 2016-06-30T18:02:06Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1151622#M632912 <HTML><HEAD></HEAD><BODY><P>Try vYear - 9:</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">pick(vYear - 9,vValue1,vValue2,...)</SPAN></P><P style="padding-left: 30px;"></P></BODY></HTML> Thu, 30 Jun 2016 18:13:20 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1151622#M632912 johnw 2016-06-30T18:13:20Z