Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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