Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
OdieW
Contributor III
Contributor III

Any way to alternate color rows in a pivot table that has a row level dimenstionality of 0 for all rows?

I have an app with a pivot table that each row is basically it's own specific measure. Currently we set the background color for every other row which is tedious but works. But then if we want to use show if conditions for some rows that can break the manual every other row alternating color. Because each row is its own unique measure each row has a dimensionality of 0 and a RowNo of 1 so I don't think I can use either of those as a base. Are there any other options I am unaware of?

Labels (1)
2 Replies
OdieW
Contributor III
Contributor III
Author

@David_Friend I did try that post. Because my pivot table has RowNo of 1 for each row, that formula will color all rows the same.