topic Re: Num Conversion in QlikView

Num Conversion

Fri, 03 Jan 2014 13:51:23 GMT

Hi,

the below expression is returning for eg 120

=num(sum([Jun 30, 2013 - Jul 06, 2013 - Rev]),'$#,##0 K')

in dta labels i want it to be displayed as $ 120 k......how the above expression should be modified for that?

Thanks

Clever_Anjos — Fri, 03 Jan 2014 13:57:27 GMT

It seems correct to me, could you post a qvw?

Clever_Anjos — Fri, 03 Jan 2014 13:59:01 GMT

How are those variables set into your app?

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

Fri, 03 Jan 2014 14:11:48 GMT

Attached is the sample qvw

preminqlik — Fri, 03 Jan 2014 14:19:49 GMT

hi find attachment

rustyfishbones — Fri, 03 Jan 2014 14:33:51 GMT

PFA,

it works using

NUM(sum([Jun 30, 2013 - Jul 06, 2013 - Rev]),'$,##0 K')

I think in the numbers tab you were not choosing Expression Default

like below

Fri, 03 Jan 2014 15:11:28 GMT

Hi Prem,

can u pls post the procedure for me.

regards

Mahesh

Fri, 03 Jan 2014 15:20:47 GMT

Thanks Allan...

preminqlik — Fri, 03 Jan 2014 17:36:53 GMT

hi mahesh,

you have to just choose money radio button in >Number tab> Money