Discussion Board for collaboration related to QlikView App Development.
I am working on a QlikView dashboard. I am using following expression for one of my KPIs
If the result is in two digits then the above expression works fine as it rounds up/down the decimal value but when it becomes 100% then I get the following result
Now if I the use following expression
Everything works fine if the result is 100% but if it is for ex: 97.89%, I will get 97.8% but I don't want the decimal digits but the rounded absolute number i.e. 98%
Any tip or suggestion will be appreciated as I am kinda confused at this point.