Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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) )
Actually the formula is =if(Even(RowNo())=-1 ,argb(40,101,173,33))
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) )
Many thanks Petter, it works !!
If( Even( RowNo(TOTAL) ) = -1 , ARGB(40,101,173,33) )