Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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.

sujeetsingh
Master III
Master III

Follow this thread

jagan
MVP & Luminary
MVP & Luminary

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.

rapradha
Contributor
Contributor

 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.

Surya
Creator II
Creator II

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.