topic Re: Num Format in QlikView

Num Format

bharatkishore — Tue, 08 Mar 2016 07:34:38 GMT

Hi,

I have the following number

expression i have written is

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #,##0')

But i need output as

$37.16.

Can you guys please help me on this

Thanks,

Bharat

Re: Num Format

Chanty4u — Tue, 08 Mar 2016 07:40:48 GMT

did u tried

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #.#0')

Money#([urfield])

Re: Num Format

avinashelite — Tue, 08 Mar 2016 07:41:30 GMT

Did not get your requirement ...could you elaborate more...

you need to round of the values to thousand or laks ?? how

Re: Num Format

bharatkishore — Tue, 08 Mar 2016 07:43:25 GMT

Hi Chanty,

I have tried this but i am getting the value as

3768579921.16(without comma)

Re: Num Format

avinashelite — Tue, 08 Mar 2016 07:46:40 GMT

if you need the comma try like this

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ ###,###,###,###,###,##0')

Re: Num Format

Digvijay_Singh — Tue, 08 Mar 2016 07:47:27 GMT

Try like '$ ##,#0.00'

Re: Num Format

bharatkishore — Tue, 08 Mar 2016 07:49:17 GMT

Hi Avinash,

I have given the expression as

sum(Amount).

I am getting the value as 3768579921.16

Now i need to get value as integer with dollar symbol and i have given expression as

num(Sum([LC2 Amount]),'$ #,##0').

After giving this expression i am getting the value as $3,768,579,921

But now my requirement is in need to get the above value as

$37.16(round with two decimals and numbers in millions).

Hope you got it..

Re: Num Format

bharatkishore — Tue, 08 Mar 2016 07:50:46 GMT

I tried your expression Digvijay but the first numbers should be only 2 numbers instead of 6 to 7 integers.

Re: Num Format

Digvijay_Singh — Tue, 08 Mar 2016 08:03:27 GMT

=num(3768579921.16/100000000,'$ ##.00')

Re: Num Format

jagan — Tue, 08 Mar 2016 08:09:52 GMT

Hi,

Try this

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #,##0.00')

Regards,

Jagan.