topic Re: Dimension name in a pivot table in QlikView

Dimension name in a pivot table

_CD_ — Fri, 29 Aug 2014 16:17:10 GMT

Hello all !

I try to know the dimension on each line in a pivot table, like this :

It looks great. Each total lines matchs with the right dimension level.

But if my table contains conditional expression for enable it, the result is (Example of add conditional expression for Market.Market1_Alias field) :

The second total line is now Market.Market2_Alias but the result of my function is Market.Market2_Alias. Unfortunately, I understand why.

Do you think there's a possibility to have :

Market.Market_Alias	Market.Market2_Alias	=Dimensionality()	=GetObjectField(Dimensionality())
zzzzyyyyxxxxx	zzzzzzz	2	-
	yyyyyy	2	-
	xxxxxxx	2	-
	Total	1	Market.Market2_Alias
Total		0	Market.Market_Alias

Thanks in advance for your help !

Christophe

Re: Dimension name in a pivot table

Fri, 29 Aug 2014 16:24:06 GMT

Instead of Getobjectfield(dimensionality()) , could you use this expression - if(Dimensionality()=2,null(),Getobjectfield(Dimensionality()) ..

Re: Dimension name in a pivot table

_CD_ — Fri, 29 Aug 2014 16:31:38 GMT

The problem is that GetObjectField() used Dimensionality() for dimension level and don't look at possible conditionnal dimension.

Dimensionality() = 0 remains for 1st dimension,

Dimensionality() = 1 remains for 2nd dimension,

Dimensionality() = 2 remains for 3rd dimension,

etc...

even if 2nd dimension is disabled.

Re: Dimension name in a pivot table

JonnyPoole — Fri, 29 Aug 2014 16:50:59 GMT

i'm a little confused by the 2nd screenshot. there are only 2 dimensions instead of 3. What is the condition that you used ? possible to share a QVW sample ?

Re: Dimension name in a pivot table

_CD_ — Mon, 01 Sep 2014 07:32:09 GMT

That's my problem. I remove a dimension with a condition like 0=1. But the function =GetObjectField(Dimensionality()) don't look at that.