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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-09-11 03:19 AM

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

419 Views
0 Likes
0 Replies