Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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 - Master III
Partner - Master III

it should work.

It works actually.

Can you share sample?

isaiasdd
Creator
Creator
Author

I added the example on question.

shraddha_g
Partner - Master III
Partner - Master III

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