Qlik Community

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 
Search instead for 
Did you mean: 
satishkurra
Specialist II
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
Michael_Tarallo
Employee
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

View solution in original post

7 Replies
satishkurra
Specialist II
Specialist II
Author

Any one?

satishkurra
Specialist II
Specialist II
Author

Any help.

Anil_Babu_Samineni

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)
Michael_Tarallo
Employee
Employee

Hi Satish I will take a look
Regards,
Mike Tarallo
Qlik
satishkurra
Specialist II
Specialist II
Author

Hi Mike

Any update?

Thanks

Satish

Michael_Tarallo
Employee
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
satishkurra
Specialist II
Specialist II
Author

Thanks Mike