topic Re: Pivot Table in QlikView

Pivot Table

krishna20 — Tue, 10 Mar 2015 07:02:13 GMT

Hi,

Is there any way to bring stripes in pivot table for a row? In style tab stripes every option is in disable.How can we bring stripes for rows.Can anyone pls help me out?

Regards

Krishna

Re: Pivot Table

Gysbert_Wassenaar — Tue, 10 Mar 2015 08:59:06 GMT

Click on the + sign in front of the expression on the Expressions tab. Choose Background Color and enter an expression like =if(Even(RowNo(TOTAL)),rgb(230,230,230),white()). Do the same for the last dimension.

Re: Pivot Table

krishna20 — Tue, 10 Mar 2015 10:43:33 GMT

Hi Gysbert,

Thank you for your reply.I'm not getting the required one. The first row color is missing. I checked by using Odd property also, the color is applying for first two rows and alternate.I think the first row is considering as zero and the property is not working properly.Please find the attachment for the expected one and getting result.

Regards

Krishna

Re: Pivot Table

Gysbert_Wassenaar — Tue, 10 Mar 2015 11:05:21 GMT

Looks like stripes to me. If you want the first odd rows colored instead of the even rows then change the expression to use the Odd() function or change the white() into another color.