topic Split charts in QlikView

Split charts

richard_chilvers — Thu, 10 Apr 2014 12:33:26 GMT

I would like to have a split chart where the top half is a stacked bar chart and the botom half has a bar and a line.

Not surprisingly, I cannot find a way to do this. So as a compromise, I'm happy to have two charts lined up together to look like one.

Since they have the same x-axis values, is there anyway I can ensure the x-axes line-up at all times ?

Thanks

MK_QSL — Thu, 10 Apr 2014 12:35:22 GMT

Go to axes tab of both charts..

On the dimension axes...

you will find Scale

Static Min and Static Max

Write min and max same for both charts....something like below..

Min(Aggr(SUM(Sales),Customer))

and

Max(Aggr(SUM(Sales),Customer))

richard_chilvers — Thu, 10 Apr 2014 15:50:54 GMT

That would be good, but I'm afraid on my chart the Scale section is greyed-out. Maybe its because of the type of chart ?

richard_pearce6 — Thu, 10 Apr 2014 16:01:40 GMT

Check Continuous in the Axis tab. this will enable your Min and Max for the dimension

Cheers

Richard

QlikCentral.com

MK_QSL — Thu, 10 Apr 2014 16:09:51 GMT

Select Continuous from Axes tab...