Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

alina_qlik
New Contributor II

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
Employee
Employee

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

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
1 Reply
Employee
Employee

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

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