Change row background color in Qlik Sense table when dimension changes

[EVernez89]

Hi,

I am on Qlik Sense and I would like to be able to put a background color as follows  (rows Table):

I have already tried several solutions that I found on this forum, including : 

Even(Aggr(NODISTINCT RowNo(), Ressources)), RGB(200,200,200)

It works on QlikView but not on QlikSense...

Anyone have an idea?

Thank you!

Estévan

[brunobertels]

I 

Try this 

=if(Even(Aggr(NODISTINCT RowNo(), Ressources))=0,lightgreen(),lightred())

[EVernez89]

Hi,

Thanks for your answer, but I get everything in the same color...

[ggijben · Accepted solution]

Hi @EVernez89 ,

Please see the attached QVF file. I've used the following formula in combination with the Autonumber() function in the script:

=if(Even(Resources_Color )=0,RGB(253,255,29),RGB(200,224,180))

Result:

[EVernez89]

Thank you very much, your solution works perfectly 👍

Best regards,

Estévan