Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

did you try changing number format from auto to Number

isaiasdd
Creator
Creator
Author

Yes, this works, but I think it should work automatically.


If I change the expression for e.g


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


Will work even while in the automatic.

shraddha_g
Partner - Master III
Partner - Master III

It works but cant guess why it is not working in your case.

millan123
Creator II
Creator II

Hi ,

what you are writing that one is correct, It has to work

Thanks,

Clark