Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
hi try this
floor('99.916',0.01)