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: 
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