topic Re: Decimal in QlikView

Decimal

manoranjan_d — Thu, 08 Jun 2017 08:21:48 GMT

in my expression i m using sum(sales) now i want to display the number as 2,000.12.

i want figures to 1000 seperators and only extend to 2 decimal

currently in the dash board its shows 2000.1235563

how to do this,

i want to show the number values with coma operator higher number also.

prma7799 — Thu, 08 Jun 2017 08:26:02 GMT

Num(sum(sales) ,'#.##')

prma7799 — Thu, 08 Jun 2017 08:28:39 GMT

or in chart level

manoranjan_d — Thu, 08 Jun 2017 08:29:04 GMT

this will show figures to 1000 seperators with comma?

Miguel_Angel_Baeyens — Thu, 08 Jun 2017 08:30:14 GMT

Or rather, in the chart properties > Number > click on the expression and then "Fixed to" and specify 2 decimals.

If you want all your data like that, you might want to do it in the loading script using a Round() function

manoranjan_d — Thu, 08 Jun 2017 08:35:53 GMT

thanks

prma7799 — Thu, 08 Jun 2017 08:37:34 GMT

Hi Manoranjan,

If you get your answer please mark this thread helpful or right answer.

Thanks.