topic Re: Help With Pick match Condition in QlikView

Help With Pick match Condition

naveen341 — Sat, 16 Nov 2024 02:25:39 GMT

HI team

I Am trying to convert number to MIllion/Billions,

I have a Variable vScaleTotalARBal which return M or B or K

i am using pick match like vDivParam=Pick(alt(match($1,'B','M','K',''),0),1000000000,1000000,1000,1)

now if i use $(vDivParam(vScaleTotalARBal)) ir is returning null .

Thanks in Advance

sunny_talwar — Fri, 20 Sep 2019 16:02:55 GMT

Are you storing vDivParam with an equal sign? If you are, then I suggest getting rid of the sign

Pick(alt(match($1,'B','M','K',''),0),1000000000,1000000,1000,1)

naveen341 — Fri, 20 Sep 2019 18:13:45 GMT

Hi Sunny It is not working i am not sure what i am doing wrong

sunny_talwar — Fri, 20 Sep 2019 18:15:26 GMT

Attaching the file I tested on