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
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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. 

View solution in original post

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