Discussion board where members can get started with QlikView.
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
Attaching the file I tested on
View solution in original post
Are you storing vDivParam with an equal sign? If you are, then I suggest getting rid of the sign
Hi Sunny It is not working i am not sure what i am doing wrong