topic Number formatting (Auto) not working for "Count" measures in App Development

Number formatting (Auto) not working for "Count" measures

drjoffily — Wed, 25 Jul 2018 00:31:01 GMT

Hi all,

We've just upgraded our environment to Qlik Sense June 2018 and are experiencing a cosmetic issue in our KPIs.

The KPIs that use a measure with Count() and have the Number Formatting as "Auto" are showing the full unformatted number instead of the abbreviations "k", "M" and "G".

Have anyone had this issue?

Re: Number formatting (Auto) not working for "Count" measures

caio_caminoski — Wed, 01 Aug 2018 10:50:36 GMT

Hi Marcos,

We are having the same issue here after upgrading. Could you solve it?

Thanks

Caio

Re: Number formatting (Auto) not working for "Count" measures

kenphamvn — Wed, 15 Aug 2018 03:34:23 GMT

Me Too

Auto format not work on Count function

maybe it's qlik june issue

Regards,

An Pham

Re: Number formatting (Auto) not working for "Count" measures

stefano_draghi — Fri, 24 Aug 2018 12:44:17 GMT

Since the formula format overwrites the auto format, you could use this as a work around.

However, I don't know if it's possible to use the NumericalAbbreviation variable in the Num() function.

Re: Number formatting (Auto) not working for "Count" measures

EmmaC — Thu, 20 Sep 2018 14:38:18 GMT

I am also having this issue! Could you solve it? without editing every master measure???

Re: Number formatting (Auto) not working for "Count" measures

mikkeltaylor — Fri, 19 Oct 2018 13:49:15 GMT

has this been fixed yet in a patch or later version?

Re: Number formatting (Auto) not working for "Count" measures

PaulSteyn_ — Fri, 11 Jan 2019 01:49:12 GMT

Of you add an alt(,0) function around your expression, and leave the number format on Auto, it solves the issue

Count(Sales) needs to be change to Alt(Count(Sales),0)

Re: Number formatting (Auto) not working for "Count" measures

mgranillo — Fri, 21 Jun 2019 21:13:02 GMT

Anyone know if this was fixed or if it's a reported bug?