Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_CD_
Contributor III
Contributor III

Dimension name in a pivot table

Hello all !

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

Sans titre.png

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) :

Sans titre.png

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())
zzzzyyyyxxxxxzzzzzzz2-
yyyyyy2-
xxxxxxx2-
Total 1 Market.Market2_Alias
Total 0 Market.Market_Alias

Thanks in advance for your help !

Christophe

4 Replies
Not applicable

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

_CD_
Contributor III
Contributor III
Author

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.

JonnyPoole
Employee
Employee

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 ?

_CD_
Contributor III
Contributor III
Author

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