topic Re: Number format not working for Count? in App Development

Number format not working for Count?

dineshraj — Wed, 15 Feb 2017 09:12:32 GMT

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

Re: Number format not working for Count?

Chanty4u — Wed, 15 Feb 2017 09:18:42 GMT

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

Re: Number format not working for Count?

rahulpawarb — Wed, 15 Feb 2017 09:19:09 GMT

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

Re: Number format not working for Count?

dineshraj — Wed, 15 Feb 2017 09:26:57 GMT

Hi Chanty,

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

Re: Number format not working for Count?

dineshraj — Wed, 15 Feb 2017 09:27:51 GMT

Hi Rahul,

I knew it but need to get it num.

Re: Number format not working for Count?

rahulpawarb — Wed, 15 Feb 2017 09:59:59 GMT

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

Re: Number format not working for Count?

mohan_1105 — Mon, 16 Jul 2018 10:25:25 GMT

Hi Dinesh Raj,

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

Re: Number format not working for Count?

miskinmaz — Mon, 16 Jul 2018 10:49:38 GMT

Hi,

Can you share the screenshot of what result you are getting

Re: Number format not working for Count?

mohan_1105 — Tue, 17 Jul 2018 05:49:05 GMT

Hi,

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

Re: Number format not working for Count?

miskinmaz — Tue, 17 Jul 2018 06:09:57 GMT

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))