Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to use - Dimensionality()

cancel
Showing results for 
Search instead for 
Did you mean: 
robert_mika
Master III
Master III

How to use - Dimensionality()

Last Update:

Feb 19, 2015 6:16:57 AM

Updated By:

robert_mika

Created date:

Feb 19, 2015 6:16:57 AM

Attachments

Definition:


Returns the number of dimension columns that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates.

A typical use is in attribute expressions, when you want to apply different cell formatting depending on aggregation level of data.

This function is only available in charts. For all chart types except pivot table it will return the number of dimensions in all rows except the total, which will be 0.

What does it mean?

We have Table with 4 dimensions(columns): Product,Category,Type,Sales

table.jpg

Now we want to create Pivot Table by using those Dimensions.

We are going to use only 3 of them(Product,Category,Type) and use 4th(Sales) in our expression.

The result is shown below:

This Pivot Table  has 3 dimensions so its maximum dimensionality is 3.

For better understating please see  table below.

The function is used to show on which dimensionality level each of the Pivot Table row is:

'Sugar' has dimensionality of 1 which is Total for that 'Product'.

'Salt' has dimensionality of 2 which is Total for each 'Category' of that 'Product'.

'Oil' has dimensionality of 3 which is single value for each 'Type' of the 'Product's' 'Category'.

So then more Dimension we use the greater dimensionality of our Pivot Table is.


Practical use:

1) To show the level of dimensionality:

Expression:

if(Dimensionality()=1 ,RGB(151,255,255),if(Dimensionality()=2 ,RGB(0,238,0),if(Dimensionality()=3,RGB(255,130,171))))

2) Highlight background of rows which on each level  fall into certain condition:

Expression:

if(Dimensionality()=1 and sum(Sales)<150,RGB(151,255,255),if(Dimensionality()=2 and sum(Sales)<=20,RGB(0,238,0),if(Dimensionality()=3 and Sum(Sales)<=20,RGB(255,130,171))))

LEVEL1 --> Values <140LEVEL 2 --> Values <=20LEVEL 3 --> Values <=20

Remember ligtbulb.jpg

  • To use the script below the Excel file must be saved in the same folder that your qvd file

        Otherwise you will need to make changes the this path - [Dimensionality.xlsx]

Directory;

LOAD Product,

     Category,

     Type,

     Sales

FROM

[Dimensionality.xlsx]

(ooxml, embedded labels, table is Sheet1);

Felling Qlingry?

How To /Missing Manual (25 articles)

Comments
Anonymous
Not applicable

Anonymous
Not applicable

Really thanks allot on your information given, it helps to improve the presentation layer appearance  attractiveness.

pipuindia99
Creator III
Creator III

good document

v_petrenko
Partner - Contributor III
Partner - Contributor III

Robert, I've just edited the categories list of this article, if you don't mind. Nothing common with Deployment or Management.

joydipp1988
Creator
Creator

Hi Robert,

Simple but in-depth explanation. I learned a new Qlik thing today.

Regards,

Joy

enriquem
Creator
Creator

Very good explanation about Dimensionality function!!

Regards

i_villafranca
Contributor
Contributor

Great explanation. However, I am trying to use Dimmensionality using a drill down dimmension... is it possible to use it with drill down or only plain dimmensions?

Thanks.

Anonymous
Not applicable

helpful information

capriconuser
Creator
Creator

if we want get this sum in horizontal then how i get this

Irvin182
Contributor II
Contributor II

Thank you for sharing

Version history
Last update:
‎2015-02-19 06:16 AM
Updated by: