Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Karthick30
Creator
Creator

how to restrict KPI result as 2 digits after point without considering 3 digit

Hi,

I am using KPI chart to calculate Average value. Where I am getting answer as 99.92% ( Since i am using % format in selection) .

but if I calculate manually , I will get answer as 99.916. Qlik automatically considering it as 99.92 ( Since 3rd digit is greater than 5)

Is there any way we can get the answer as 99.91 ? like Ignore 3 digit

Labels (1)
2 Replies
chris_djih
Creator III
Creator III

You can use Floor(value,step) to cut the digits after step.
So in your case to always take the first 2 digits: Floor(value, 0.01)

If you found help, mark the correct answer and give some likes to ALL contributors, that tried to help.
brunobertels
Master
Master

hi try this 

floor('99.916',0.01)