Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

num() function formatting

Hi,

I always struggle with num() function.

when I use it to format the output. I always get funny output. I have to do multiple trial & error to get the desired output.

I am curious to understand how the num() function behaves. I have gone through the qlikview help section, but still not clear. I dont know what means format-code in the below syntax and when to use decimal and thousand seperator.

num(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )

Also Could you please tell me when to use-

#

0

,

.

while formatting the number in num() function.

Regards,

Suraj

12 Replies
PradeepReddy
Specialist II
Specialist II

Hi jagan,

If  I am not wrong,

the above expression will give the result as 3525,000.

the expression for the proper format is.. num(3525,'#,##0','.',',')

Thanks, Pradeep

KD_
Contributor III
Contributor III

Thank you for the explanation. Can you or someone explain in layman terms what this part '.',',' is doing. Thank you