Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combo chart with line ignoring dimension

Hi,

Not sure if this is possible, but i am asking anyway.

I'm creating a combo chart, with dimension Month then zone.

Bar is based on both Month and Zone dimension.

then the line, is it possible to just based on month and ignoring zone?

if not possible, then the solution is to split into 2 different charts?

Thanks,

nick

3 Replies
Anonymous
Not applicable
Author

Not sure exactly what you mean here.. but you could try using Aggr() and aggregating around the Month dimension value only for the line chart. So if your expression for the line chart is sum(Sales) for example you could try sum(Aggr(sum(Sales),Month)). Not sure if this will work.. or look nice for that matter.

Not applicable
Author

Hi Johannes,

I mean, when we create a combo stacked bar chart, how can we let the line not following the second dimension?

I can do this easily like the following suggestion, but the problem is i am doing it on material code. which will be too many to hard code one by one.

there's a manual solution here - http://community.qlik.com/thread/10783

Thanks.

dapostolopoylos
Creator III
Creator III

I love you man, 8 years ago you saved my life! 😊

Father/Husband/BI Developer