topic Pivot table color formatting in QlikView

Pivot table color formatting

Fri, 14 Jan 2011 09:22:47 GMT

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!

Pivot table color formatting

sparur — Fri, 14 Jan 2011 09:56:29 GMT

Hello, yes it's possible.

you can set background color for expression, like this:

if(mod(rowno(), 2) = 1, rgb(215,215,215), white())

Pivot table color formatting

deepakk — Fri, 14 Jan 2011 10:06:13 GMT

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