Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
drjoffily
Partner Ambassador Alumni
Partner Ambassador Alumni

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

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?

7 Replies
caio_caminoski
Creator
Creator

Hi Marcos,

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

Thanks

Caio

kenphamvn
Creator III
Creator III

Me Too

Auto format not work on Count function

maybe it's qlik june issue

Regards,

An Pham

stefano_draghi
Contributor II
Contributor II

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.

EmmaC
Partner - Creator
Partner - Creator

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

mikkeltaylor
Creator II
Creator II

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

PaulSteyn_
Contributor
Contributor

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)

mgranillo
Specialist
Specialist

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