
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik Sense - Remove any decimals when formatting
Hi Qlikers,
I have a challenge on a minus number percentage without any decimals
Currently whats showing,
What want to see is = -19%
The measure I used to get the above is
(Round(Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number),)/(date(today(),'DD/MM/YYYY')-'01/10/2019'))/
(Num(Count({<FYear_Num={$(=Max(FYear_Num)-1)}>} Incident_Number),)/365)-1)* 100
AND
(Ceil(Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number),)/(date(today(),'DD/MM/YYYY')-'01/10/2019'))/
(Num(Count({<FYear_Num={$(=Max(FYear_Num)-1)}>} Incident_Number),)/365)-1)* 100
What I have tried so far but unsuccessful using example from community.
//((Sum(Sales)/Sum(Products)),'#0%').
//num(sum(Value)/sum(total Value), '#,##0%')
//=Value&'%'
//round(Count({< [Escalated Case Count] = {1}>} DISTINCT CustomID) / SUM ([Open Count]))
//num(AVG([Total CTR]), '#.##%')
Below is where I used above community given examples
(Round(Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number),'Unsucessful')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))/
(Num(Count({<FYear_Num={$(=Max(FYear_Num)-1)}>} Incident_Number),'Unsucessful')/365)-1)* 100
Anyone can help would be really appreciated. Thanks
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In the measure you should just be able to turn number formatting off of auto, turn on Number, and choose no decimal places.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you trying to do this in a KPI or table or what chart?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In the measure you should just be able to turn number formatting off of auto, turn on Number, and choose no decimal places.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Steven I was trying to do a KPI

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is my question to be honest. I am Not sure how I can do that.
Below is what I see,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got it now. Thanks
