Combo chart with two dimesions and two measures

[EQ]

Hi Expert,

I have source data like below and I want to create the Combo chart with two dimensions and two measures.

Subregion	Severity	Total Ageing	Counter
C	Low Risk	76	1
C	Low Risk	103	1
C	Medium Risk	103	1
I	Low Risk	245	1
I	Low Risk	354	1
I	Low Risk	535	1
I	Medium Risk	473	1
I	Medium Risk	1190	1
J	Low Risk	35	1
J	Low Risk	74	1
J	Low Risk	232	1
J	Low Risk	398	1
J	Low Risk	545	1
J	Medium Risk	35	1
J	Medium Risk	74	1
J	Medium Risk	1285	1

Please see the attached QVW, what I want is that combine the chart 1 and chart 2 with the stacked bar and the average line. But when I do this in Chart 3, it is really messed up.  The corrected one is like the FinalChart.png.

Would a kind and enlightened please advise on my error, many thanks in advance!

[qliksus]

You can try with trellis chart having subregion , Severity as a dimension and the Ageing and average as expression

[EQ]

Hi ,

Thanks for your suggestions, but trellis is not my solution, I just uploaded the expected chart - FinalChart.png

[anushree1 · Accepted solution]

Please check this link: https://www.youtube.com/watch?v=-WIjMxAjRA4

you could apply the same on your chart by creating one expression each for each Severity 

[EQ · Accepted solution]

Hi,

Thanks a lot for your help, it works! Meanwhile, I find another video which is using set analysis in expressions, it is better for my real charts.

https://www.youtube.com/watch?v=5RHVcdw9oYA