Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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