Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
Highlighted
isaiasdd
Contributor

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

Re: Format number is not work

it should work.

It works actually.

Can you share sample?

isaiasdd
Contributor

Re: Format number is not work

I added the example on question.

Partner
Partner

Re: Format number is not work

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
Honored Contributor III

Re: Format number is not work

you want like this

Untitled.png

Not applicable

Re: Format number is not work

Hi Isaias,

Change the number formatting to Number.

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

Thanks

Khushboo

isaiasdd
Contributor

Re: Format number is not work

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
Honored Contributor III

Re: Format number is not work

have you checked below ?

Not applicable

Re: Format number is not work

My version is QlikSense Desktop 3.1 SR3

isaiasdd
Contributor

Re: Format number is not work

Yes, this is how it should be or 2.824