num() function formatting

[surajap123]

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

[PradeepReddy]

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_]

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

[MarcoWedel]

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/Formatt...