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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sqdev
Contributor
Contributor
‎2021-06-11 05:04 AM

Qlik Sense Auto Number Format

Hi all,

I've been trying for an hour to format the number format on the right side of my screenshot like on the left side and can't find a solution.


Can someone give me a hint how to solve it ?

Thanks a lot in advance!

 

image.png

2,405 Views
1 Reply
rubenmarin
MVP
MVP
‎2021-06-12 04:20 AM

Hi, the one on the right looks like an extension, I think this formatting is done by the object, not by default, in example when you show values in table they are shown in all it's length, like on the right side os your screenshot.

One option could be editing the extension to work as the default KPI object formatting numbers. I can't help you with this.

There is a workaround to simulate that behaviour, the expression can be something like:

If([YourExpression]>1e6, Num([YourExpression]/1e6, '#.##0,0M'),
  If([YourExpression]>1e3, Num([YourExpression]/1e3, '#.##0,0k'),
    Num([YourExpression], '#.##0,0'))

 

1,986 Views