Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate coloring of pivot table columns depending on top horizontal dimension

Hi all,

in QlikView, I have a pivot table with 2 horizontal dimensions. One is always the same (in the picture "Year") and the other one that is always on top can be selected between more than 60 dimensions (in the picture "Dimension 1" but can be "Dimension 2", "Dimension 3", .... "Dimension 60").

I would like to color alternate columns depending on the selected top dimension like in the picture for each of 60 dimensions that can be selected (always just one of them at the time).

Any help would be appreciated.

Thank you,

Sara

Pivot table.png

0 Replies