topic Re: Rounding nearest Integer value for Max value in QlikView

Rounding nearest Integer value for Max value

grajmca_sgp123 — Tue, 15 Sep 2015 07:01:46 GMT

Hi ,

RangeMax(22.9,250,100) --->i will get the 250

If i use Ceil fun or round fun also i will get same results.

But my requirement is I want to get 300 which is nearest value for max value.How can we achieve.

sunny_talwar — Tue, 15 Sep 2015 07:04:15 GMT

Try this:

=Ceil(250, 100)

sunny_talwar — Tue, 15 Sep 2015 07:04:46 GMT

Or this:

=Ceil(RangeMax(22.9,250,100), 100)

senpradip007 — Tue, 15 Sep 2015 07:08:57 GMT

You can use round(RangeMax(22.9,250,100), 100) also.