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

num() function formatting


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-





while formatting the number in num() function.



12 Replies
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

Contributor III
Contributor III

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