topic Re: how to restrict KPI result as 2 digits after point without considering 3 digit in App Development

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

Karthick30 — Wed, 26 Jan 2022 17:28:15 GMT

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

chris_djih — Thu, 27 Jan 2022 10:36:04 GMT

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)

brunobertels — Thu, 27 Jan 2022 10:38:08 GMT

hi try this

floor('99.916',0.01)