Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
alina_qlik
Contributor III
Contributor III

Getting exactly same views for Group bar chart and Stacked bar chart . How to avoid it ?

Hi Experts ,

I am getting exactly similar views for Group bar chart and Stacked bar chart with same data . And i do not want that .

In the chart below , i want measure 1 and measure 2 as separate bar for each year . But its coming like stacked by default .

Is there anything wrong ? How the separate bars can be achieved ?

bars1.PNGbars2.PNG

I have attached file as well .

Thank you res ^ponders 

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

here are the rules from the Help: (https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Bar_Chart.ht...)

For the presentation of bar charts with multiple dimensions and expressions the following principles apply:

  • A maximum of two dimensions can be shown on the x-axis.
  • A third dimension can be shown with multicolored stacked bars.
  • Only table charts can display more than three dimensions.
  • When two or more expressions are enabled, the two first dimensions are shown on the x-axis and the expression with multicolored stacked bars.
  • When two or more expressions are enabled and the subgroup is set to stacked, all expressions within one stack will be calculated according to one axis (by default the left). This will be the case even if you set one expression to be calculated according to the left axis and one to be calculated according to the right axis.

The following table shows how subtypes are presented with multiple dimensions and expressions.

Dimensions Expressions Subtype
1 1 Single bar
1 2 or more Expressions are grouped or stacked
2 1 Dimensions are grouped or stacked
2 2 or more Dimensions are grouped
3 1 1st and 2nd dimensions are grouped, 3rd dimension is stacked
3 2 or more 1st and 2nd dimensions are grouped, expressions are stacked
4 1 1st and 2nd dimensions are grouped, 3rd dimension is stacked
4 2 or more 1st and 2nd dimensions are grouped, expressions are stacked

View solution in original post

1 Reply
Lisa_P
Employee
Employee

here are the rules from the Help: (https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Bar_Chart.ht...)

For the presentation of bar charts with multiple dimensions and expressions the following principles apply:

  • A maximum of two dimensions can be shown on the x-axis.
  • A third dimension can be shown with multicolored stacked bars.
  • Only table charts can display more than three dimensions.
  • When two or more expressions are enabled, the two first dimensions are shown on the x-axis and the expression with multicolored stacked bars.
  • When two or more expressions are enabled and the subgroup is set to stacked, all expressions within one stack will be calculated according to one axis (by default the left). This will be the case even if you set one expression to be calculated according to the left axis and one to be calculated according to the right axis.

The following table shows how subtypes are presented with multiple dimensions and expressions.

Dimensions Expressions Subtype
1 1 Single bar
1 2 or more Expressions are grouped or stacked
2 1 Dimensions are grouped or stacked
2 2 or more Dimensions are grouped
3 1 1st and 2nd dimensions are grouped, 3rd dimension is stacked
3 2 or more 1st and 2nd dimensions are grouped, expressions are stacked
4 1 1st and 2nd dimensions are grouped, 3rd dimension is stacked
4 2 or more 1st and 2nd dimensions are grouped, expressions are stacked