Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thank you for the explanation. Can you or someone explain in layman terms what this part '.',',' is doing. Thank you