topic Re: Maximum Number of Dimension in QlikView

Maximum Number of Dimension

Anonymous — Tue, 03 Jul 2012 18:50:37 GMT

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

Re: Maximum Number of Dimension

cesaraccardi — Tue, 03 Jul 2012 21:03:38 GMT

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

Re: Maximum Number of Dimension

hic — Tue, 03 Jul 2012 21:04:39 GMT

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

Re: Maximum Number of Dimension

Anonymous — Wed, 04 Jul 2012 09:21:23 GMT

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

Re: Maximum Number of Dimension

Thu, 05 May 2016 22:54:20 GMT

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 ?

Re: Maximum Number of Dimension

SunilChauhan — Fri, 06 May 2016 05:57:16 GMT

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

Re: Maximum Number of Dimension

SunilChauhan — Fri, 06 May 2016 05:58:00 GMT

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

Re: Maximum Number of Dimension

ramasaisaksoft — Fri, 06 May 2016 10:57:19 GMT

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

Re: Maximum Number of Dimension

hic — Mon, 09 May 2016 12:08:12 GMT

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

Re: Maximum Number of Dimension

Anonymous — Fri, 13 Apr 2018 16:24:37 GMT

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

Re: Maximum Number of Dimension

mark_casselman — Fri, 22 Feb 2019 10:05:47 GMT

As noted in another thread titled "More than 10 rows/dimensions in QlikSense extension", I believe the number of dimensions is limited to 10.