Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate Row colors in Pivot table

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.

pivot color.bmp

Thanks,

JKM.

4 Replies
tresesco
MVP
MVP

Could not really understand the issue.

Not applicable
Author

Hi,

Please find the attached QVW.

Thanks,

JKM

ThornOfCrowns
Specialist II
Specialist II

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.

yduval75
Partner - Creator III
Partner - Creator III

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)