Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
joshm43
Contributor II
Contributor II

Issue when formatting with NUM() and measure expression

Good day -

I am having an issue when attempting to use embedded formatting with NUM() in an expression.  The expression I am using is:

=if(vTest='Numbers',

NUM((count(distinct{​​​​​​​<Score={​​​​​​​'>8'}​​​​​​​, SentimentScore={​​​​​​​'>3'}​​​​​​​>}​​​​​​​Record_ID)), '#,##0.0') ,

NUM( ((count(distinct{​​​​​​​<Score={​​​​​​​'>8'}​​​​​​​, Sentiment={​​​​​​​'>3'}​​​​​​​>}​​​​​​​Record_ID)) /(Count({​​​​​​​$<Category2 = >}​​​​​​​ Record_ID))),     '#,##0%'))

I have the Number formatting on the chart set to "Measure Expression" (This is a Vizlib chart).

The numbers calculate correctly when viewed in a table, but only the first value formats correctly.

The second value formats with an "m" - e.g. "34m". 

If anyone has any ideas on what this might be and how to resolve, it would be much appreciated.

Thanks!

Labels (2)
0 Replies