Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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