Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

how to show the Avg of all the sections as data point on a stacked bar chart

Hi All,

Requirement: I have to show Average lead time for each team and region. So Team is my primary dimension and Region my second which will create the sections in the bar. and appear as legends. 

Now for example, Team A has a avg lead time 2 days for all the 5 different regions. The value on top of the stacked bar would be 10  but I want it do be 2 i.e Avg rather than the sum of avg lead time for each region.

Please let me know how can i implement this.

Thanks,
Pranav 

3 Replies
Highlighted
Creator II
Creator II

Re: how to show the Avg of all the sections as data point on a stacked bar chart

You just need to add another expression with avg([Dimension]) and uncheck bar and check values on data points. I have attached an example.

Highlighted
Creator II
Creator II

Re: how to show the Avg of all the sections as data point on a stacked bar chart

Hi, 

thanks for the suggestion but how come the avg time for Team B is coming as 10?

It should be 6, right?

 

Regards,
Pranav 

Highlighted
Creator II
Creator II

Re: how to show the Avg of all the sections as data point on a stacked bar chart

I figured out a workaround but it is not ideal. I have a separate bar chart (not stacked) that displays the average with invisible bars. and on top I have the stacked bar chart with invisible dimension font. They must be lined up just right. Hopefully you can get that to work with your data.