Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shubham_kumar
Creator III
Creator III

Maximum Number of Dimension

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

10 Replies
cesaraccardi
Specialist
Specialist

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

Henric_Cronström

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

shubham_kumar
Creator III
Creator III

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

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 ?

TigerisBack
Champion
Champion

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

TigerisBack
Champion
Champion

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

ramasaisaksoft

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

Radar              Only 1             No limit

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

Henric_Cronström

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

Dimensionality.png

HIC

darsichaitanya
Contributor III
Contributor III

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