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: 
neha_sharma1275
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]

=if(Even(RowNO(total))=0,LightBlue(),Green())

    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.

neha_sharma1275_0-1623241811478.png

 

Help is highly appreciated !

 

Thanks,

Neha

 

 

1 Reply
Ben_at_Kohls
Contributor III
Contributor III

I have the same issue if anyone has any ideas.