Trendline in a line chart with 2 dimensions.

[#1]

Hi,

I have a chart looking like this in Excel that I try to create in Qlikview without success.

I have tried in QV by using the built-in functions for trendlines but it doesn't seem to work when I have 2 dimensions (YearMonth and ProductNr).

I have also tried adding an expression for calculating the average but when I activate both expression the first expression will be aggregated.

Any suggestion on how to solve this?

best regards,

Johan

[#2 · Accepted solution]

I am not sure whether you tried this but I placed the second chart (transparent) on top of the first chart and it replicates the excel chart...

The problem will arise if you have to display the chart key

Find attached

[#3]

Hi,

It's not a bad idea to put it on top but there seems to be problems with the scale when selecting a specific YearMonth. It might be possible to adjust the scales to be in sync though.

If I don't find any other solutions this will do.

Thanks!

Johan

[johnw]

I've been poking at this some. It seems like the kind of thing that should be simple, but I haven't found any better solution than overlaying two charts. The main problem with that is what you've already noticed - the scales don't always line up. My normal fix for that is to go to the Axes tab and use an expression for the Static Max. In this case, you could use this expression:

max(aggr(sum(Errors),YearMonth,ProductNr))

[#5]

Hi,

Thanks for your answers. I have not found any other solution but this one and it helped fixing the Static max with the function you provided. The only setback is the maintenance of 2 objects and the auto minimize function that I had to set off. Beside from this it works really good.

best regards,

Johan