Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
isaiasdd
Creator
Creator

Format number is not work

Hi,

I have the expression below:

num(count(code), '#.##0')

I expected the number 1.500, but I received a 1,5k.

Why, num() don't work with count() ?

13 Replies
shraddha_g
Partner
Partner

it should work.

It works actually.

Can you share sample?

isaiasdd
Creator
Creator
Author

I added the example on question.

shraddha_g
Partner
Partner

same thing works with my data in my app.

It would be better if you put it with sample data so that someone can see why it is not working in your case.

arulsettu
Master III
Master III

you want like this

Untitled.png

Not applicable

Hi Isaias,

Change the number formatting to Number.

Now the current setting must Automatic. Hence that K is coming.

Thanks

Khushboo

isaiasdd
Creator
Creator
Author

What version you it is using ?

I am using a qlik sense desktop version 3.1 SR3.

I have a version 3.0 SR3 in server.

But it does not work in any version. I have tested with different apps, but stay equal in all.

arulsettu
Master III
Master III

have you checked below ?

Not applicable

My version is QlikSense Desktop 3.1 SR3

isaiasdd
Creator
Creator
Author

Yes, this is how it should be or 2.824