Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

align axis within combochart to same scale

hi there,

similar to this chart in the upper right at 2:30 https://youtu.be/RkVDi0b2hmk?t=150

I want to create a combo chart with a metric on the left and another target metric using lines and the right axis. as seen in the video, this doesn't make sense if those two axis don't align and share the same scaling.

so is there a smart solution to align those two ? automatic scaling works good for a single axis, but not for both

I came up with calculating the scale limits for both like

 

=if(
max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth]))
	>max(aggr(Sum(Value),[Date...YearMonth]))
,max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth]))
,max(aggr(Sum(Value),[Date...YearMonth]))
)

 

which translates to: if(left axis > right axis, left axis, right axis)

but this is a very fragil approach and is also doesn't react two changes of the x-axis.

any ideas ?

thanks;

alex

 

Labels (5)
1 Solution

Accepted Solutions
Highlighted
Creator
Creator

ok, found out myself.

possible to assign it to the primary axis when line chart is selected as second measure

View solution in original post

1 Reply
Highlighted
Creator
Creator

ok, found out myself.

possible to assign it to the primary axis when line chart is selected as second measure

View solution in original post