QlikSense Gauge Issue

[azmeerrehan]

I am using Qlik Sense. I have a Gauge showing -10%,0% ,10%. We are comparing Sales from Last Year. If the sales are more then last year  for example 109% they will be shown as (9%), which is working fine,but if the sales this year are less then 100 percent compared to last year  for example 94% (Gauge shows the needle in Red which is good but , the -6% should show ass 6% without the negative sign. Is there a way to accomplish that.

Please see attached

[Quy_Nguyen]

Hi Rehan,

Change your measure number formatting to Custom with pattern: #,##0;#,##0

[azmeerrehan]

I have a needle

[azmeerrehan]

Can u pls upload the QVF?

[Quy_Nguyen · Accepted solution]

Take a look at the attached qvf file.