Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paulaugust
Partner - Contributor
Partner - Contributor

QlikView coloring lines alternately with grey and white in a Pivot table

QlikView coloring lines alternately with grey and white in a Pivot table

 

Labels (1)
4 Replies
Ray_Strother
Support
Support

Hello ,

You can edit the Pivot Table  by Right Clicking  > Properties > Expressions > Expand  > Background Color > 

Use an expression like this : =if (Mod(RowNo(),2)=0, Yellow(),LightCyan())

paulaugust
Partner - Contributor
Partner - Contributor
Author

Thanks a lot, it works:)

paulaugust
Partner - Contributor
Partner - Contributor
Author

Do you think it is possible to alternate the colors for the dimensions as well.....one would need something like groupno instead of rowno. This is how it looks like for the dimensions.

paulaugust_0-1694670018390.png

 

paulaugust
Partner - Contributor
Partner - Contributor
Author

and for the expressions it does not work as well. 

paulaugust_1-1694670158665.png