Alternate row colors except repeating values

neha_sharma1275 — Wed, 09 Jun 2021 12:43:23 GMT

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.

Help is highly appreciated !

Thanks,

Neha

Re: Alternate row colors except repeating values

Ben_at_Kohls — Tue, 10 May 2022 19:50:30 GMT

I have the same issue if anyone has any ideas.

topic Alternate row colors except repeating values in QlikView

Alternate row colors except repeating values

Re: Alternate row colors except repeating values