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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator II
Creator II

Colors in pivot table

Good morning,

 

i would like to color the measures in my pivot table with blue when there is the dimension Month and with another color when i see the values inside the first dimension.

 

Carlaf_93_1-1619006087436.png

 

So i would like the first 5 in blue and all the others in whyte.

How can i do it?

 

1 Reply
Carlaf_93
Creator II
Creator II
Author

I found this one:

if(even(Dimensionality()),WHITE(),RGB(174,206,244))

it works.. but when the dimension is not expanded i get all a color..