Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Alternate row colors except repeating values

Hi Experts,

I have a requirement where the rows should be alternate colors but for repeating values the color shouldn't change. I have achieved the alternate row colors(below is the screenshot) using this formula in the Background color of dimension [Part ID]


    BUT  I am not able to make the same row color if the values repeat. for example, in the below screenshot it should be - 1st Part ID - Blue, 2nd Part ID - Blue again , 3rd Part ID - Green and rest of the rows having alternate row colors.



Help is highly appreciated !






1 Reply
Contributor III
Contributor III

I have the same issue if anyone has any ideas.