Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
fzalexanderjohn
Creator
Creator

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
timpoismans
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
timpoismans
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

fzalexanderjohn
Creator
Creator
Author

It works just as I want, thank you!