Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense - Remove any decimals when formatting

Hi Qlikers,

I have a challenge on a minus number percentage without any decimals

Currently whats showing,

YG_0-1599792171750.png

 

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 

 

 

Labels (4)
1 Solution

Accepted Solutions
Steven_Haught
Creator III
Creator III

@YG 

In the measure you should just be able to turn number formatting off of auto, turn on Number, and choose no decimal places. 

View solution in original post

5 Replies
Steven_Haught
Creator III
Creator III

Are you trying to do this in a KPI or table or what chart? 

Steven_Haught
Creator III
Creator III

@YG 

In the measure you should just be able to turn number formatting off of auto, turn on Number, and choose no decimal places. 

YG
Contributor III
Contributor III
Author

Hi Steven I was trying to do a KPI

YG
Contributor III
Contributor III
Author

That is my question to be honest. I am Not sure how I can do that. 

Below is what I see,

YG_0-1600125751097.pngYG_1-1600125780131.png

 

YG
Contributor III
Contributor III
Author

I got it now. Thanks

YG_2-1600126499992.png