Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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:
I
Try this
=if(Even(Aggr(NODISTINCT RowNo(), Ressources))=0,lightgreen(),lightred())
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:
Thank you very much, your solution works perfectly 👍
Best regards,
Estévan