topic Re: Area chart with overlay line chart in QlikView

Area chart with overlay line chart

Fri, 22 Nov 2013 23:27:01 GMT

HI All,

I need to generate a an area chart for current forecast with a line chatr representing the previous year forecast. We would normally use Excel to do this, setting current forecast as the Area and the last one as the Line - no problem in Excel. To do this in QV I've had to create two charts, an area chart (line with fill) and a line chart - I then overlay these two charts. My problem arises in that the Y-ases of the two charts need to be identical. I would like to set the axis of the line chart equal to that of the Area chart. Can anyone advise how I can achieve this

Many Thanks

John

Re: Area chart with overlay line chart

MK_QSL — Sat, 23 Nov 2013 08:26:34 GMT

Go to Axis...

Under Scale...

Set Static Min as

=if(Min(Aggr(SUM(LYForecast),Month))<Min(Aggr(SUM(CYForecast),Month)),

Min(Aggr(SUM(LYForecast),Month)),

Min(Aggr(SUM(CYForecast),Month))

)

and Static Max as

=if(MAX(Aggr(SUM(LYForecast),Month))>MAX(Aggr(SUM(CYForecast),Month)),

MAX(Aggr(SUM(LYForecast),Month)),

MAX(Aggr(SUM(CYForecast),Month))

)

For both charts...

Please check enclosed sample file..

Dont forget to keep one chart layout at top/normal and another as bottom.

Re: Area chart with overlay line chart

Anonymous — Sat, 23 Nov 2013 11:11:57 GMT

John

Have tried a Combo Chart ?

Best Regards, Bill

Re: Area chart with overlay line chart

MK_QSL — Sat, 23 Nov 2013 11:16:28 GMT

Combo chart will not give filled area chart !!

Re: Area chart with overlay line chart

Sat, 23 Nov 2013 13:41:26 GMT

Hi Misha,

That worked perfectly Very elegant

I hear that QlikTech are planning to improve their charting in the next version.. look forward to that