Number format not working for Count?

[dineshraj]

Hi all,

         I have this problem recently. Num format not working for Count.

I am using this expression.

num(Count(DocId),'#,##0')

Can any one solve this

Thanks in advance

[Chanty4u]

can you show the values of your field and what your expecting?  and what your getting on the above expression?

[rahulpawarb]

Hello Dineshraj,

In Qlik Sense, select the measure you want to format. Go to the number formatting section of that measure and Select Number option & 1,000 as format.

Regards!

Rahul

[dineshraj]

Hi Chanty,

Its just an example num format not working for count.I have tried to count Sales employee

[dineshraj]

Hi Rahul,

I knew it but need to get it num.

[rahulpawarb]

Not sure, why it is not picking up the defined formatting.

[mohan_1105]

Hi Dinesh Raj,

Did you find any solution? I'm facing a similar issue.

[miskinmaz]

Hi,

Can you share the screenshot of what result you are getting

[mohan_1105]

Hi,

I solved this issue by selecting "Measure Expression" instead of Auto in number formatting.

[miskinmaz]

Hi,

You can use below expression for num format if the filed has another decimal and thousand format..

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

also try for

num(num#(field))