Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
EQ
New Contributor III

Combo chart with two dimesions and two measures

Hi Expert,

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

SubregionSeverityTotal AgeingCounter
CLow Risk761
CLow Risk1031
CMedium Risk1031
ILow Risk2451
ILow Risk3541
ILow Risk5351
IMedium Risk4731
IMedium Risk11901
JLow Risk351
JLow Risk741
JLow Risk2321
JLow Risk3981
JLow Risk5451
JMedium Risk351
JMedium Risk741
JMedium Risk12851

 

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!

 

 

2 Solutions

Accepted Solutions
anushree1
Valued Contributor

Re: Combo chart with two dimesions and two measures

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
New Contributor III

Re: Combo chart with two dimesions and two measures

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

 

4 Replies
qliksus
Valued Contributor II

Re: Combo chart with two dimesions and two measures

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

 

EQ
New Contributor III

Re: Combo chart with two dimesions and two measures

Hi ,

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

anushree1
Valued Contributor

Re: Combo chart with two dimesions and two measures

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
New Contributor III

Re: Combo chart with two dimesions and two measures

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