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

alina_qlik — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

I have attached file as well .

Thank you res ^ponders

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

Lisa_P — Mon, 01 Jul 2019 05:25:19 GMT

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