topic Re: What does ['$#,##0'] means in following script ?? in QlikView

What does ['$#,##0'] means in following script ??

nikhilgarg — Fri, 26 Sep 2014 05:19:01 GMT

Hey,

Can anyone tell me why is this ['$#,##0'] used in following script ?? What does every letter of it denotes ??

='Actual : ' & num(sum({<[Expense Category] = {'Food'}>} Amount), '$#,##0')

Thanks

deepakqlikview_123 — Fri, 26 Sep 2014 05:36:28 GMT

$#,##0 will denote number uptp 4 palces like $1,234 etc.

This is simply formatting

sushil353 — Fri, 26 Sep 2014 05:37:28 GMT

Hi,

This is for number formatting.

$ sign will be added to the starting of no..

#,##0 represents that a coma ',' will come on thousand point.

0 represent no decimal value will come..

Try using in text box: =num(2132.31,'$#,##0')

HTH

Sushil

Fri, 26 Sep 2014 05:39:54 GMT

Money Format...

out put will be

$1,000

$10,000

$2,005

anbu1984 — Fri, 26 Sep 2014 05:44:06 GMT

$#,##0 - Format of the number with prefix $ and 0 at the end round digits after decimal point

Num(1111111,'$#,##0') -- $1,111,111

Num(1111111.9,'$#,##0') -- $1,111,112

Num(1111,'$#,##0') -- $1,111

Num(111,'$#,##0') -- $111

Num(111.1,'$#,##0') -- $111

SunilChauhan — Fri, 26 Sep 2014 05:55:15 GMT

its mean you are converting sum({<[Expense Category] = {'Food'}>} Amount) into format of 1,234 i.e Interger in Number Tab.

$ is just syblol for denoting amount in dollar.

hope this helps

maxgro — Fri, 26 Sep 2014 05:58:50 GMT

to test number formatting

goto number tab in a chart

set a number format

and see the result (preview and format pattern) at the right