Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Help With Pick match Condition

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 

Labels (2)
1 Solution

Accepted Solutions
Highlighted

Attaching the file I tested on

View solution in original post

3 Replies
Highlighted

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)

 

 

image.png 

Highlighted
Creator
Creator

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

clipboard_image_0.png

Highlighted

Attaching the file I tested on

View solution in original post