Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Kohli
Contributor

Change the number format?

there is a number value in a field called 'sales' as 555235. How to display the number in the format '555,235'?

4 Replies
amit_saini
Honored Contributor III

Re: Change the number format?

num(Sales,'#,##0')

Thanks,

AS

Re: Change the number format?

This will make more sense

=Num(555235,'#,##,##0')

immkhan2
New Contributor II

Re: Change the number format?

The above two serves the purpose but a little more elaborated for Num function

Num(number[, format[, dec_sep [, thou_sep]]])

Re: Change the number format?

Try like this

num(Sales,'###,##0')