Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to make a pivot table morer readable by showing the result in alternating color, say 1st line is white, 2nd line is grey, 3rd line is white.... etc
Is there any way to do such formatting?
Thanks!
Hello, yes it's possible.
you can set background color for expression, like this:
if(mod(rowno(), 2) = 1, rgb(215,215,215), white())
hi,
There is a option Custom format cell for the pivot table. IN order to enable it you need to change the mode of the application to design Grid.
You will find that option in Design Toolbar.
Once you are in that mode right qlik on the pivot table --> custom format cell. ...
I hope this helps you..