Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

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

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

Hi Paulyeo11


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



7 Replies
paulyeo11
Valued Contributor II

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

Enclosed my QV doc.

paulyeo11
Valued Contributor II

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

Hi All

Can some one share with me this one.

Paul

chauhans85
Esteemed Contributor

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

see the attached file

ravic906
Contributor III

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

Hi

may be like this

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

HTH

Ravi  N.

Not applicable

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

Hi Paulyeo11


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



paulyeo11
Valued Contributor II

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

Hi Sir

Thank you it work fine now.

Paul

paulyeo11
Valued Contributor II

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

Hi Sunil

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

Paul

Community Browser