Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to set condition when amount more then $10 round up ?

Hi All

I have an issue , my amount vary from $0.01 till $100,000

In situation amount more then $10 i need round up. and amt less then that i don't want it to round up.

Because

0.10 if round up to 0.5 is a very big diff

10.1 round up to 10.5 is a vey small diff

Paul

1 Solution

Accepted Solutions
Not applicable

Hi Paulyeo11


Ravichandran expression is correct, u can go through the attached application for sample.



View solution in original post

7 Replies
paulyeo11
Master
Master
Author

Enclosed my QV doc.

paulyeo11
Master
Master
Author

Hi All

Can some one share with me this one.

Paul

SunilChauhan
Champion
Champion

see the attached file

Sunil Chauhan
Anonymous
Not applicable

Hi

may be like this

if(points>=10,Round(points),points)

HTH

Ravi  N.

Not applicable

Hi Paulyeo11


Ravichandran expression is correct, u can go through the attached application for sample.



paulyeo11
Master
Master
Author

Hi Sir

Thank you it work fine now.

Paul

paulyeo11
Master
Master
Author

Hi Sunil

Just saw yr approach , very innovative , let me think , i may apply your into my doc.

Paul