topic Re: Converting money into Symbol in QlikView

Converting money into Symbol

Anonymous — Thu, 23 Apr 2015 08:53:41 GMT

Hi All,

How to convert amount into million ,billions in straight table. In number tab Symbol option is not enabled after selecting the inter option also.

Please Help me.

Thanks in advance.

Re: Converting money into Symbol

morganaaron — Thu, 23 Apr 2015 09:14:59 GMT

Write it into a Num() expression, like:

If(Sum(Sales)>1000000000, Num(Sum(Sales)/1000000000, '##0.00B'), Num(Sum(Sales)/1000000, '##0.00M'))

Which would give you your data in billions or millions.

Re: Converting money into Symbol

Thu, 23 Apr 2015 09:18:08 GMT

Do this,

Properties ->Number->

Select the relevant expression-> (you want the result)

Select Integer(mark)

Then,

Apply-> Ok

Priyantha.

Re: Converting money into Symbol

jagan — Thu, 23 Apr 2015 09:30:00 GMT

Hi,

In Straight table this options will be disabled, since straight table do not have X and Y axis. If you want this you have to do this manually like below

=If(Sum(Measure) > 1000000000, Num(Sum(Measure)/1000000000, '##0.00B'),

If(Sum(Measure) > 1000000, Num(Sum(Measure)/1000000, '##0.00M'),

Num(Sum(Measure)/1000, '##0.00K')))

Hope this helps you.

Regards,

Jagan.

Re: Converting money into Symbol

Anonymous — Thu, 23 Apr 2015 10:19:36 GMT

Thankyou Jagan Mohan and aaron Morgan

Re: Converting money into Symbol

jagan — Fri, 24 Apr 2015 07:32:56 GMT

Hi Anusha,

If you got the Answer close this thread by giving Correct Answer to the useful post.

Regards,

Jagan.

Re: Converting money into Symbol

Mon, 15 Feb 2016 09:28:39 GMT

what if i have multiple measures like combination chart

Re: Converting money into Symbol

jagan — Tue, 16 Feb 2016 01:52:22 GMT

Add some additional conditions to the If().

Regards,

Jagan.