topic Re: Text Object. Num query / rounding up in QlikView

Text Object. Num query / rounding up

knightwriter — Wed, 15 Jul 2015 14:37:32 GMT

Hi All,

I have created a text box object to a sum a number in USD. I can get the sum to work and I have inucluded =num(sum(sales), '$##,###.')

How do I round this number up? ie $31,123,123 to $31m?

Many thanks

sunny_talwar — Wed, 15 Jul 2015 14:39:31 GMT

May be this:

=Num(Sum(sales)/1000000, '$##,###.') & 'm'

sunny_talwar — Wed, 15 Jul 2015 14:40:21 GMT

Or may be this:

=Dual(Num(Sum(sales)/1000000, '$##,###.') & 'm', Num(Sum(sales), '$##,###.'))

knightwriter — Wed, 15 Jul 2015 14:40:36 GMT

Ah yes! Didnt even think to /1000000!

Thank you sunindia

sunny_talwar — Wed, 15 Jul 2015 14:41:19 GMT

No problem.

Glad I was able to help.

Best,

Sunny