topic Re: SecondaryDimensionality Function in QlikView

SecondaryDimensionality Function

Anonymous — Mon, 29 Sep 2014 10:47:28 GMT

Hello,

I'm trying to SecondaryDimensionality function to know if the cell is the total one on a pivot table.

However the function max(SecondaryDimensionality()) doesn't work, always return 0 in every cell.

The max(Dimensionality) function works well.

In attach you'll see that SecondaryDimensionality() returns 1 and on the same cell the max returns 0.

Anyone one can explain this?

Thanks all

Anonymous — Mon, 29 Sep 2014 17:01:06 GMT

The problem is that max(SecondaryDimensionality()) always return 0, even when SecondaryDimensionality() returns 1 or greater

Tue, 11 Nov 2014 06:36:45 GMT

Hi Ricado

Have you solve this issue?

I face the same problem Max(SecondaryDimensionality()) always return 0,

Rgds,

Alex

Anonymous — Fri, 13 Feb 2015 17:32:18 GMT

You can't use it like that, QlikTeck said max(Dimensionality) worked but just for luck.

Within Max function you need to have an array with values