Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
youss123
Contributor II
Contributor II

Compare sales of each region with the average sales of all regions on bar chart

Hi all,

I have a bar chart that displays average sales by region.

I want to make in  all the bars a point that displays the average of all regions.

I explained more in the draw attached,

Thank you in advance.

average.PNG

 

1 Solution

Accepted Solutions
Taoufiq_Zarra

@youss123  if I understood correctly

in averge you need to use total like

avg(total sales)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@youss123  if I understood correctly

in averge you need to use total like

avg(total sales)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
youss123
Contributor II
Contributor II
Author

it worked. thank you very much