topic Money in QlikView

Money

Fri, 07 Oct 2011 16:20:34 GMT

Hi,

How to round of using the below one

if the money value is 5678999.23 then it should display as 56.23 lakhs. I am ableto display the y axis value as 50 lakhs by using the propery Money.But still the expression value is showing the entire amount. Is it possible to achive using money.

Money

Fri, 07 Oct 2011 16:36:47 GMT

set the expressions format as well

Re: Money

Fri, 07 Oct 2011 17:20:01 GMT

You can try using expression symbol, thousand symbol etc in Number tab. There is no lakhs symbol though.

You can always try num(<expression>/100000,'0.00 Lakhs')

Regards,

Kiran.

Money

Fri, 07 Oct 2011 18:00:17 GMT

Hi Jollybaba,

Thanks for your response. As of now i am dividing by 100000, Would like to know the same can be achived using the Money function.

Money

Fri, 07 Oct 2011 18:11:24 GMT

try using something like

=money( 23425366/10000, 'Rs #,##0', '.' , ',' )

Money

Fri, 07 Oct 2011 18:12:20 GMT

of course you can replace the 23425366 with <expression>