Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

general question

hello guys,

if i got two dimension,then we will give like

dimensionality()=1 for first dimension

dimensionality()=2 for sec dimension

so now

dimensionality()=0 ?(is it represence  for TOTAL )?

2 Replies
MVP
MVP

Re: general question

This indicates the depth in a pivot table -- the number of dimensions for that line.

For example, a pivot with 4 dimensions:

     Detail - dimensionality() = 4

     Subtotal on 4th dimension - dimensionality() = 3    

     Subtotal on 3rd dimension - dimensionality() = 2

     Subtotal on 2nd dimension - dimensionality() = 1

     Total - dimensionality() = 0

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: general question

Dimensionality() applies to the row dimensions. If a dimension is dragged to the top to make a cross table, you need to use SecondaryDimensionality() to work out the dimensionality of the columns.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein