New to QlikView

Discussion board where members can get started with QlikView.

Contributor III

Maximum Number of Dimension

What can be the maximum number of dimension in a chart?

9 Replies
Valued Contributor

Re: Maximum Number of Dimension

Hi, i think it depends on the chart you are using... If you want a gauge chart you wont use any dimension, a bar/line chart usually uses 1-2 dimensions, 2-3 dimensions in the grid chart, a pizza chart usually 1 dimension...

Regards,
Cesar

Employee

Re: Maximum Number of Dimension

There are two limitations: One is the formal number of Dimensions and the other is the memory aspect.

The formal number of dimensions depends on which chart. For example, a bar chart can have 3 Dimensions and 1 Expression (or 2 Dim and several Expr). A pie chart can have 2 Dimensions and 1 expression. But a pivot table can have any number of dimensions and any number of expressions.

The memory aspect is worse. A chart is a cube, which means that the memory usage increases exponentially with the number of dimensions. How many dimensions you can have depends on how many distinct values they have. A simple rule of thumbs is: Never more than 4 dimensions.

HIC

Contributor III

Re: Maximum Number of Dimension

So can I believe that maximum number of dimension is 3 or lets conclude from Henric's answer that pivot chart can include any number of dimension..but should be avoided due to performance issue!!

Best Regards,

Shubham

Not applicable

Re: Maximum Number of Dimension

Henric, I can't find maximum no of dimensions and expressions for each chart object in the documentation. Can you please route me where can I get this details ?

Esteemed Contributor

Re: Maximum Number of Dimension

I thing 2 is max to plot   when you have more that 2 dimension it will plot but it will not be legible. so suggest you to 2 Dimesion

Esteemed Contributor

Re: Maximum Number of Dimension

you can use cyclic Group and add n number of dimensions. but it will work one dimension one time

Valued Contributor III

Re: Maximum Number of Dimension

Hi Subham

Chart Type    Dimension    Expression

Bar                  Atmost 2         no limit

Line                  only 1             No limit

Pie                  Atmost 2         only 1

Gauge             no dimension    no limit

Pivot                No limit            No limit

Straight            No limit            No limit

Grid                 Atleast 3          only 1

Mekko             Only 1             No limit

Bloack             No limit           Only 1

Funnal             Only 1             Only 1

Scatter             No limit           Atmost 2 and 3rd expression decide the size of symbol

Combo             Atmost 2         No limit

Employee

Re: Maximum Number of Dimension

To find the largest number of dimensions, you need to understand the concept of "Dimensionality". See  Chart Dimensionality.

For example, a bar chart with two dimensions and one measure has dimensionality=2. But the same is true for a bar chart with one dimension and several measures. So basically, you can calculate the dimensionality using

= NumberOfDimensions + If(NumberOfMeasures>1, 1, 0)

Further, there is a difference between what is possible and what is sensible. The software allows a pie chart with two dimensions and one measure (i.e. dimensionality=2) but in my experience it is not sensible to create such a thing. The user should understand what he is looking at...

With this definition, the table looks like

HIC

New Contributor

Re: Maximum Number of Dimension

I think Pivot is said as Table not a Chart. hope so.