Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to get alternating row colors in a table within Qlik Sense. I am using this expression for the measure, where cGrey and cWhite are variables with color codes in them. I have 4 dimensions.
=if(Even(RowNO(total))=0,cGrey,cWhite)
When I have the RowNO(total) as a measure field, it works as expected, but as soon as I remove that column, it shows incorrectly.
How can I correct this so that every other row is grey?
=IF(mod(RowNo(),2),red(),Green())
it will help you
Thank you, but that does not work. It turns ever row one color. I also tried with 'total' and the same behavior happens from my original question.
=IF(mod(RowNo(),2),cGrey,cWhite) -> turns all rows grey
=IF(mod(RowNo(total),2),cGrey,cWhite) -> same behavior as original question
where you doing color expression
may be attach will help
I am putting the expression in the Background Color of the dimension.
=IF(mod(RowNo(),2),red(),Green())
=if(Even(RowNO(total))=0,LightBlue(),Green())
if(mod(RowNo(total),2)=0,green(),blue())
one of these expressions should work
Would someone from Qlik be able to look at this and see if it is a bug or working as designed?