topic Re: Round up number? in QlikView

Round up number?

oliviatww — Fri, 12 Sep 2014 03:21:35 GMT

Hi there,

I know it is possible to round up decimal like 32.65 to 33. But is it possible to round a number from 47,825 to 48,000 in Qlikview?

Any help is appreciated.

Thanks

jagan — Fri, 12 Sep 2014 03:27:04 GMT

Hi,

Try like this using Round()

=Round(47825, 1000)

Regards,

Jagan.

oliviatww — Fri, 12 Sep 2014 03:34:33 GMT

Hi Jagan,

That's what I want. I was trying something like round(47,825, 1,000) but pops out error (probably due to the commas).

But anyway thanks for your help.

Kind regards,

Olivia

jagan — Fri, 12 Sep 2014 03:47:59 GMT

Hi,

If you have values in dimension or set analysis expression then try like this

Round(Sum(Sales), 1000)

Round(Sales, 1000)

Hope this helps you.

Regards,

jagan.

Fri, 12 Sep 2014 04:07:01 GMT

Hi,

U can use this Round(sum(Sales),1000)

PFA.

Best Regards,
Shenne Tannavi