Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Y Axis Scale Combo Chart QlikSense

Thanks Mike