topic Re: Strips in pivot table in QlikView

Strips in pivot table

sampada0810 — Wed, 29 Jun 2016 06:52:59 GMT

I want to have color banding in pivot table

please find the following image

i want to achieve a similar kind of report in QlikView

I can mention the 'strips' property in straight table but no such option is present in pivot table.

How can I Achieve it?

Re: Strips in pivot table

Gysbert_Wassenaar — Wed, 29 Jun 2016 14:20:03 GMT

It's easier in a straight table. If you have only one metric Cost then I don't see why you need a pivot table. A straight table will work fine in that case. You can enable the "Stripes every ... Rows" option on the Style tab.

The alternative is to use the Background Color settings of the dimensions and expressions. Click on the + in front of the expression on the Expressions tab, select Background Color and then enter an expression to calculate the background color:

Do the same for the dimensions.

Re: Strips in pivot table

krishnacbe — Wed, 29 Jun 2016 14:20:52 GMT

Hi,

you can use Custom Format Cell option to achieve this.

Right click on the table and select the Custom Format Cell option.

Re: Strips in pivot table

sampada0810 — Thu, 30 Jun 2016 06:25:23 GMT

Thanks Gysbert Wassenaar.

Actually the picture which I have attached is just a sample to show the banding.

the scenario which I am facing is I have 2 cyclic groups in dimension and I want banding.

The way you told is correct, I have achieved what I want

Thanks for your help!