Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
avinashkk696
New Contributor III

understanding Dimensionality()=0

Hello All,

I have a recently started working on the Qlikview and we have a dashboard with some pivot charts. In the pivot charts, I have come across an expression,

IF((Dimensionality()=0  or  RowNo()>0)  and (ColumnNo() >0 or SecondaryDimensionality() =0),Sum(Sales))


I couldn't understand what does dimensionality()=0 does and what is rowno()>0 does. I know what is dimensionality() and columnno() is. 


Please help me with it. I got struck here.

Thanks in advance..

1 Solution

Accepted Solutions
qlikviewnovice
Valued Contributor II

Re: understanding Dimensionality()=0

or Maybe Total is Dimensionless row so it will be 0. Using condition Dimensionality()=0 we can format/color the

" Total "row differently.

8 Replies
qlikviewnovice
Valued Contributor II

Re: understanding Dimensionality()=0

Hi

Have a look: How to use - Dimensionality()

Hope it helps!!

Sergey_Shuklin
Valued Contributor

Re: understanding Dimensionality()=0

Hello, Avinash!

About difference between Dimensionality you can read here

dimensionality Vs secondarydimensionality

RowNo() returns current number of row in pivot table.

qlikviewnovice
Valued Contributor II

Re: understanding Dimensionality()=0

SecondaryDimensionality ( )

Returns the number of dimension pivot table rows that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates. This function is the equivalent of the dimensionality() function for horizontal pivot table dimensions.

The secondarydimensionality() function always returns 0 when used outside of pivot tables.



The second dimension... or how to use secondarydimensionality()

Hope it helps!!

vinieme12
Esteemed Contributor II

Re: understanding Dimensionality()=0

i think the person is trying to avoid showing Totals in both horizontal and vertical total rows and keeping them blank

qlikviewnovice
Valued Contributor II

Re: understanding Dimensionality()=0

or Maybe Total is Dimensionless row so it will be 0. Using condition Dimensionality()=0 we can format/color the

" Total "row differently.

vinieme12
Esteemed Contributor II

Re: understanding Dimensionality()=0


or Maybe Total is Dimensionless row so it will be 0  : 

This is INcorrect, only that last total row has a dimensionality() value of 0, that indicates it is partial sum for the first dimension in the table, similarly     

The Dimensionality() value depends on the order of field in the pivot table.

  try it by creating a pivot with 3 fields and check partial sums for the 1st and third dimension and then promote the Third dimension to second and you will see the dimensionality() value changes

qlikviewnovice
Valued Contributor II

Re: understanding Dimensionality()=0

Hi Vineeth,

Please find attached file for your reference

vinieme12
Esteemed Contributor II

Re: understanding Dimensionality()=0

for what?