topic Re: Combo chart with line ignoring dimension in QlikView

Combo chart with line ignoring dimension

Mon, 01 Oct 2012 08:57:16 GMT

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

Re: Combo chart with line ignoring dimension

Anonymous — Mon, 01 Oct 2012 09:20:39 GMT

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.

Re: Combo chart with line ignoring dimension

Mon, 01 Oct 2012 09:28:10 GMT

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.

Re: Combo chart with line ignoring dimension

dapostolopoylos — Thu, 26 Nov 2020 09:08:53 GMT

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