Round up number?

[oliviatww]

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 · Accepted solution]

Hi,

Try like this using Round()

=Round(47825, 1000)

Regards,

Jagan.

[oliviatww]

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]

Hi,

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

Round(Sum(Sales), 1000)

OR

Round(Sales, 1000)

Hope this helps you.

Regards,

jagan.

[#5]

Hi,

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

PFA.

Best Regards,
Shenne Tannavi