Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Converting money into Symbol


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.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

7 Replies
morganaaron
Specialist
Specialist

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.

Not applicable
Author

Do this,

Properties ->Number->

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

Select Integer(mark)

Then,

Apply-> Ok

Priyantha.

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author


Thankyou  Jagan Mohan and aaron Morgan

jagan
Luminary Alumni
Luminary Alumni

Hi Anusha,

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

Regards,

Jagan.

Not applicable
Author

what if i have multiple measures like combination chart

jagan
Luminary Alumni
Luminary Alumni

Add some additional conditions to the If().

Regards,

Jagan.