Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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)