Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Only color one Dimension in Pivot Table

Hello,

I habe a pivot table with 3 Levels: Manufaturer, Type and Produkt. I want to a apply a color code just to Type independant how to Pivot Table is sorted.

So, if Type is Dimension 1 it should apply there just as when Type is Demension 3. So I can't use something like

if(Dimensonality()=",'green') because it should also work if the user changes the order of dimensions.

Is this possible?

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hi

Try the following:

If(GetObjectDimension(Dimensionality()-1)='Type',Green())

This should work, even if you re-arrange dimensions.

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

Hi

Try the following:

If(GetObjectDimension(Dimensionality()-1)='Type',Green())

This should work, even if you re-arrange dimensions.

View solution in original post

Highlighted
Contributor III
Contributor III

It works just as I want, thank you!