Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ranjit1958
New Contributor III

How to restrict values to 2 decimal points without rounding it off?

Hi,

I need to restrict the values on a table upto 2 decimal points with rounding off the values.

Ex: if value = 0.556, I need the value as 0.55 and not 0.56.

I tried using the Floor(value, 0.01) function and Left(Value,4), But these functions doesn't give the desired output.

- Am also suppressing the null values that is one of the reasons am facing issue.

Can anyone please help me out here?

Thanks

4 Replies

Re: How to restrict values to 2 decimal points without rounding it off?

Would you be able to share a sample where you have this problem?

Re: How to restrict values to 2 decimal points without rounding it off?

Floor() will helps you. Can you share image?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: How to restrict values to 2 decimal points without rounding it off?

Hi!!

Try using this

num(expression,'#,##.##');

or

num(expression,'#,##.00');

ogautier62
Valued Contributor II

Re: How to restrict values to 2 decimal points without rounding it off?

Hi,

floor(0.556, 0.01) gives 0.55

what's wrong for you ?

regards