Use of $,#

[Anonymous]

Hai,

num(sum([Sales Amount]), '$#,##0')  what is the use of $,# in this.Can anyoune clear my dbt.

Thanks in advance

[Chanty4u]

Hi,

this link may helps you

how to use num() function in qlikview?

[Anil_Babu_Samineni · Accepted solution]

Here, $ - will act as Static

Assume, If your Sales Amount value seems 3403 -- Output you will receive as $3403 //As i said $ is static here. Some users need to show that sales amount into USD Currency they followed this

And # - It act as Format of out data point

#,##0 -- If you have around 3403 -- Then it will give 3,403 //Here, Comma is the special to neat and clean values

Finally you will get like below $3,404

[Anonymous]

Thanks anil.