Average line for each group in a bar chart with 3 dimensions.

[Anonymous]

Hello,

I would like to draw an average line for each group in a bar chart with 3 dimensions.

Here falls an example :

My real qlikview chart falls behind :

[jmvilaplanap]

Hi,

I think an approach is use one single dimension in the x axis (year) and define the background color depending the President dimension.

Regards

[Anonymous]

I would like to draw an average line for each group in a bar chart. Here, for each year.

What the point with the background color ?

[jmvilaplanap]

Sorry, I was thinking about the look & feel.

For the average, you can create value with a set analysis and show them in the char as a different expressions, isn´t it?

Regards

[Anonymous]

Yes but if the selection changes, this solution doesn't work anymore.

For example, if I select 2016 and 2017 and after that I change to 2017 and 2018.

Your solution works only if you know what will be selected.

[Anonymous]

In fact, this is impossible to do that with QlikView.

Thanks anyway Jose.