Qlik Sense Auto Number Format

sqdev — Fri, 11 Jun 2021 09:04:16 GMT

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!

Re: Qlik Sense Auto Number Format

rubenmarin — Sat, 12 Jun 2021 08:20:22 GMT

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'))

topic Re: Qlik Sense Auto Number Format in App Development

Qlik Sense Auto Number Format

Re: Qlik Sense Auto Number Format