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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Format Number (in Thousand)

Hi guys,

just a quick question,

How to display number with thousand format in qlik sense ?

Usually in Excel, I just add dot or comma in custom format to display my number in thousand.

Can Qlik sense do that ?

Please advice

Thanks

Henry

31 Replies
Taraun
Contributor II
Contributor II

'A' don't work

Sum(OPSUM) = 2201

num(sum(OPSUM), '0A') = 2201A

But i expect 2k

tealowk
Partner - Contributor III
Partner - Contributor III

Hi Mek, 

Has this feature request been abandoned? In fact, it would be quite handy to access the "3:k;6:M" notation via a format statement without actually having to manipulate the number.

 

Cheers,

Thilo