Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
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.
Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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