topic Visual guides in a Pivot Table in QlikView

Visual guides in a Pivot Table

Wed, 15 Feb 2012 17:03:59 GMT

Hello everyone,

i was wondering if there's a way to combine colors in the backgrond of a pivot table to use them as visual guides(like pyjama stripes in a straight table), i would like to get a pivot table to look like this.

if anyone can help i qould apriciate it

Best regards.

Visual guides in a Pivot Table

pover — Wed, 15 Feb 2012 19:24:10 GMT

I wouldn't recommend using so many colors, but if you enable the Design Grid found in the View menu option, you can right-click on the table column and you will see an option called Custom Format in the right-click menu. That will allow you to change the background color of that column.

Or, you can use an expression like if(rowNo()/2=floor(rowNo()/2),LightBlue(),Blue()) in the background color of the column in your pivot table to color alternate rows differently.

Karl

Visual guides in a Pivot Table

Wed, 15 Feb 2012 21:14:52 GMT

Thanks, Karl - I never knew that how to change cells and headers like that. Very helpful!

Visual guides in a Pivot Table

Wed, 22 Feb 2012 18:24:39 GMT

Thank you very much Karl that expression it's indeed what i was looking for, sorry about the late answer i was very busy, thats a lot your help it's apreciated

Best regards.

Re: Visual guides in a Pivot Table

Anders_Eriksson — Mon, 16 Mar 2015 10:33:51 GMT

> if(rowNo()/2=floor(rowNo()/2),LightBlue(),Blue())

What a complicated way of calculating Even!

Try if(Even(RowNo()), LightBlue(), Blue()) instead.