# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for
Did you mean:
Specialist II

## Y Axis Scale Combo Chart QlikSense

Hi All

I'm trying to create a chart with time period as x axis and Left Y axis is Sum(Revenue) in Millions (I used custom format as #,##0 M). So it is displaying Millions on Scale

However on Right Y axis, i use below expression and set Number format as Measure Expression

If(Match(unit, 'Index'),Num(Avg([Home Value]),'#,##0.0'),
If(Match(unit, 'Dollars','Price','Volume','Number'),
if(Sum([Home Value]) > 1000000, num(Sum([Home Value])/1000000, '#,##0.0 M'),

if(Sum([Home Value]) > 1000, num(Sum([Home Value])/1000, '#,##0.0 K'), num(Sum([Home Value]), '#,##0'))),
If(Match(unit, 'Ratio'),Num(Avg([Home Value]),'#,##0.00'),
If(Match(unit, 'Rate'),Num(Avg([Home Value]),'#,##0.0%')
))))

The issue is y Axis scale is showing up as 0, 1K, 2k.... (1K is 1000 and 2k is 2000)

I need to display the scale also as 0, 100 M, 200 M....etc

Is there anyway we can set this option?

Thanks

Satish

1 Solution

Accepted Solutions
Employee
Hi Satish - check this out: https://community.qlik.com/t5/Qlik-Design-Blog/NumericalAbbreviation-Variable/ba-p/1475800 - let me know if this helps.
Regards,
Mike Tarallo
Qlik
7 Replies
Specialist II
Author

Any one?

Specialist II
Author

Any help.

If you can see, There is an Y-Axis Arbitrary like Ranges using Min/Max in the presentation section.
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Employee
Hi Satish I will take a look
Regards,
Mike Tarallo
Qlik
Specialist II
Author

Hi Mike

Any update?

Thanks

Satish

Employee
Hi Satish - check this out: https://community.qlik.com/t5/Qlik-Design-Blog/NumericalAbbreviation-Variable/ba-p/1475800 - let me know if this helps.
Regards,
Mike Tarallo
Qlik
Specialist II
Author

Thanks Mike