topic Color Coding for alternate rows in a pivot table in QlikView

Color Coding for alternate rows in a pivot table

Fri, 09 May 2014 03:41:22 GMT

Hi,

I have a requirement wherein the rows of the pivot table must be represented via two colors red and green alternatively i.e., 1st row must be in red, 2nd must be in green, 3rd in red,4th in green and so on. Can anyone please let me know how this could be accomplished

Re: Color Coding for alternate rows in a pivot table

eduardo_sommer — Fri, 09 May 2014 04:01:33 GMT

Use, in all dimensions and expressions of the pivot table, in the background property, the following expression

if (mod(rowno(total),2)=0,lightred(),lightgreen())

Eduardo

Re: Color Coding for alternate rows in a pivot table

jagan — Fri, 09 May 2014 05:32:03 GMT

Hi,

Try like

Chart Properties -> Expression -> Expand the + symbol for expression -> Click on Background and enter the following expression in Definition textbox

=If(Mod(RowNo(TOTAL), 2) = 0, RGB(255, 0 , 0),RGB(0, 255, 0))

Regards,

Jagan.

Re: Color Coding for alternate rows in a pivot table

Fri, 09 May 2014 06:08:54 GMT

Write the below expression in Expression + symbol(background color):

=if(even(rowno()),Green(),Red())

Hope this will help you.