topic Re: Use of $,# in QlikView

Use of $,#

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hai,

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

Thanks in advance

Re: Use of $,#

Chanty4u — Wed, 15 Feb 2017 06:48:52 GMT

Hi,

this link may helps you

how to use num() function in qlikview?

Re: Use of $,#

Anil_Babu_Samineni — Wed, 15 Feb 2017 06:51:49 GMT

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

Re: Use of $,#

Anonymous — Wed, 15 Feb 2017 06:53:57 GMT

Thanks anil.