How to compare front end values only till 2 decimals in qlikview

[#1]

Hi Qlikview Devs,

I am comparing two expressions which give decimal value numbers. I am rounding it off to two decimals in front end(In number Tab).

After rounding it off to two decimals I am highlighting the lowest value among the two. The two values displayed are as follows:

Expr1 : 94.12%

Expr2 : 94.12%

Here Expression1 is getting highlighted as red.

When I round it off to 14 decimal places in the number tab the expression values are as follows:

Expr1 :94.11764705882352

Expr2 : 94.11764705882401

The comparsion actually takes place with the entire number before rounding it off. But it is misleading in the front end as both the numbers appear equal.

Any solution/suggestion qlikers??

Thanks and Regards,

Pratik

[pokassov]

Hello!

Rounding on the number page is just round on screen.

Use round(your_expression,0.01)

[#3]

Thanks for the reply. How to convert it to percent?

by multiplying by 100 or any other function is there?

[pokassov · Accepted solution]

Well,

1. change your expressions:

round(expression,0.0001)

2. on Number page select Number Format Settings "Fixed to", 2 Decimals, Show in Precent (%)