New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Not applicable

how many dimension we can add in bar chart andline chart?

how many dimension we can add in bar chart andline chart?

5 Replies
Not applicable

Re: how many dimension we can add in bar chart andline chart?

It depends on the data but ideally 3 dimensions on bar & 2 on line can be added.

If dimensions are interdependent like Timeline then you can also make it cyclic or drilldown.

Honored Contributor III

MVP & Luminary

Re: how many dimension we can add in bar chart andline chart?

Hi,

From Qlikview Reference Manual (Page No. 620)

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.

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.

Regards,

Jagan.

Highlighted
New Contributor

Re: how many dimension we can add in bar chart andline chart?

1st and 2nd dimensions are grouped, 3rd dimension is stacked regarding this how can we make an bar chart with the 3rd dimension as stacked.

Could you please give an example.

Contributor

Re: how many dimension we can add in bar chart andline chart?

we can add number of. but bar chart taken first 2 dimensions only..That's the limitation of Bar chart.

Line chart also same.

when you want third dimension using groups or else using enabled condition.