Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
L_VN
Partner - Contributor III
Partner - Contributor III

Color every second row of a indented pivot table

So if you don't indent the rows of a pivot table then coloring every second row is trivial; ```IF(Even(Row(Total)), Blue(), White())```, but this does not work when "Indent rows" is selected in the pivot table. Does anyone have a workaround for this? 

 

Labels (1)
8 Replies
anat
Master
Master

yes , when "Indent rows" is selected in the pivot table above color expression will not work as expected.

Peter_Adams
Employee
Employee

Can you share your app?

L_VN
Partner - Contributor III
Partner - Contributor III
Author

Is there a way of coloring every second row in a pivot table with indented rows? 

L_VN
Partner - Contributor III
Partner - Contributor III
Author

The question isn't specific to my app. It is more so a question on if it's possible to color every second row in a pivot table with indented rows.

Peter_Adams
Employee
Employee

I will try to replicate.  If you can't share your app, is this in QS Client-Managed or QS SaaS?

L_VN
Partner - Contributor III
Partner - Contributor III
Author

This specific case was on prem, however, I haven't been able to do it on any instance of Qlik 

Peter_Adams
Employee
Employee

So in my test, the coloring every other row worked, but was disjointed between columns.  Is that what you observed?

Peter_Adams
Employee
Employee

I created this using the Ctrl-00 script.  What would you like to see?Pivot Coloring.png