Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you show the values of your field and what your expecting? and what your getting on the above expression?
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
Hi Chanty,
Its just an example num format not working for count.I have tried to count Sales employee
Hi Rahul,
I knew it but need to get it num.
Not sure, why it is not picking up the defined formatting.
Hi Dinesh Raj,
Did you find any solution? I'm facing a similar issue.
Hi,
Can you share the screenshot of what result you are getting
Hi,
I solved this issue by selecting "Measure Expression" instead of Auto in number formatting.
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))