Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

bargraph with 3 bars for each dimenision

I have a bar graph which shows the sum(Sales) for each country . Now I want two additional bars for each dimension that shows the average(Sales) and Max(Sales) for a specific country. however, adding (Max)sales or Avg (Sales) as an additional measure is giving the same value for all the Dimension(country), and not the average and max for that specific Dimension(Country).

3 Replies
Or
MVP
MVP

I just created a matching bar chart and I am getting the expected result - each bar behaves as per the formula within. You may need to share a sample app or otherwise specify what's going on within your app in order to help pinpoint the issue.

Or_0-1633613737357.png

 

Qlikuser09
Creator II
Creator II
Author

 

First bar =(Sum({<[Country={'ProductNAme'}>}Salesvalue)) - Total for a specific product name 

second bar = Max({$<[Country]>}Salesvalue)- Max of all the products for the specific country

Thirdbar = Avg({$<[Country]>}(Salesval)) Average of all the products for the specific country.

The first a bar gives the correct value, however average(third bar ) and max bar  is  giving me an incorrect answer

Or
MVP
MVP

If you remove the set analysis from your second two bars, you should get the average and max for the country assuming that is your dimension for the chart.