Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dineshraj
Contributor

Number format not working for Count?

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

9 Replies
sureshqv
Esteemed Contributor III

Re: Number format not working for Count?

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

rahulpawarb
Valued Contributor II

Re: Number format not working for Count?

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
Contributor

Re: Number format not working for Count?

Hi Chanty,

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

dineshraj
Contributor

Re: Number format not working for Count?

Hi Rahul,

I knew it but need to get it num.

rahulpawarb
Valued Contributor II

Re: Number format not working for Count?

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

mohan_1105
Contributor III

Re: Number format not working for Count?

Hi Dinesh Raj,

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

miskinmaz
New Contributor III

Re: Number format not working for Count?

Hi,

Can you share the screenshot of what result you are getting

mohan_1105
Contributor III

Re: Number format not working for Count?

Hi,

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

miskinmaz
New Contributor III

Re: Number format not working for Count?

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

Community Browser