topic Re: Alternate Row colors in Pivot table in QlikView

Alternate Row colors in Pivot table

Mon, 07 Apr 2014 10:40:15 GMT

Hi,

Is it possible to give alternate row color to pivot table in the way I have given in the attachment?

I'm able to give alternate row colors for Manager and assistant manager using even(rowno()) and odd(rowno()) functions but 3,4,5 columns need more than 1 rows to be colored same hence I'm not able to use the rowno() function. Any help is appreciated.

Thanks,

JKM.

Re: Alternate Row colors in Pivot table

tresB — Mon, 07 Apr 2014 11:00:09 GMT

Could not really understand the issue.

Re: Re: Alternate Row colors in Pivot table

Mon, 07 Apr 2014 12:05:02 GMT

Hi,

Please find the attached QVW.

Thanks,

JKM

Re: Alternate Row colors in Pivot table

ThornOfCrowns — Mon, 07 Apr 2014 12:09:31 GMT

OP requires that the rows in columns 'Technology', 'Ratings' and 'Percent' are coloured alternatively. I don't think it can be done in that pivot, but others may be brighter than me.

Re: Alternate Row colors in Pivot table

yduval75 — Mon, 07 Apr 2014 13:12:23 GMT

You can add a field "Technology_number" with a load inline or other.
Then, use the function as you have done but with the new field : even(Technology_number) or odd(Technology_number)