topic Re: How to show number with comma in QlikView

How to show number with comma

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

Hi,

How can I the number as :

217053472 as 217,053,472 .

To Display the values for SALES/DEMAND I used Text Object.

Is there any other to display the values

My Output should look like :

Re: How to show number with comma

sunny_talwar — Tue, 26 Apr 2016 11:13:39 GMT

Try using Num() function

Num(YourExpression, '#,##0')

Replace YourExpression with the existing function you have

Re: How to show number with comma

trdandamudi — Tue, 26 Apr 2016 11:17:20 GMT

Use Num function and see a sample below:

Num(Sum(Amount) / Business_Days_Available,'#,##0.0')

Re: How to show number with comma

Kushal_Chawda — Tue, 26 Apr 2016 11:21:17 GMT

=Num(sum(SalesPerDemand),'#,#00')

Use your actual expression

Re: How to show number with comma

swuehl — Tue, 26 Apr 2016 11:22:11 GMT

The num() function should do what you want, sometimes you need to explicitely define both separators to make it work correctly:

Num(YourExpression, '#,##0.','.',',')

Re: How to show number with comma

Peter_Cammaert — Tue, 26 Apr 2016 11:26:32 GMT

Actually, the num() function becomes interesting after the second parameter, because parm 3 & 4 allow you to change decimal and thousands separators.

If for example, ThousandSep = '.' and DecimalSep = ',' by default (because they're set like that in your system/load script), you can change them in the UI by using

=num(SumValue, '#,###.00', '.', ',')

See also QV Desktop Help articly for function num(). It comes with some good examples.

Peter