Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QlikView coloring lines alternately with grey and white in a Pivot table
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())
Thanks a lot, it works:)
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.
and for the expressions it does not work as well.