Alternate colour in straight table

[enricocamerin]

Hello,

to create an alternate colour background in the table I used this formula

=if(Even(RowNo())=0,argb(40,101,173,33))

It works for the measure in a Pivot table, but it doesn't work if you apply the formula in a straight table

qliksense June 2018

thanks

[enricocamerin]

Actually the formula is =if(Even(RowNo())=-1 ,argb(40,101,173,33))      

[petter · Accepted solution]

You probably have to add TOTAL as there are more than one dimension in your table:

If( Even( RowNo(TOTAL) ) , ARGB(40,101,173,33) )

[enricocamerin]

Many thanks Petter, it works !!

If( Even( RowNo(TOTAL) ) = -1 , ARGB(40,101,173,33) )