Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
satishkurra
Valued Contributor 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
Employee

Re: Y Axis Scale Combo Chart QlikSense

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
Highlighted
satishkurra
Valued Contributor II

Re: Y Axis Scale Combo Chart QlikSense

Any one?

satishkurra
Valued Contributor II

Re: Y Axis Scale Combo Chart QlikSense

Any help.

Re: Y Axis Scale Combo Chart QlikSense

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
Employee

Re: Y Axis Scale Combo Chart QlikSense

Hi Satish I will take a look
Regards,
Mike Tarallo
Qlik
satishkurra
Valued Contributor II

Re: Y Axis Scale Combo Chart QlikSense

Hi Mike

Any update?

Thanks

Satish

Employee
Employee

Re: Y Axis Scale Combo Chart QlikSense

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
Valued Contributor II

Re: Y Axis Scale Combo Chart QlikSense

Thanks Mike