Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

enricocamerin
New Contributor III

Alternate colour in straight table

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Alternate colour in straight table

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) )

3 Replies
enricocamerin
New Contributor III

Re: Alternate colour in straight table

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

MVP
MVP

Re: Alternate colour in straight table

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
New Contributor III

Re: Alternate colour in straight table

Many thanks Petter, it works !!

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

Community Browser