Pivot table background colour problem

[#1]

I have a pivot table that colours the first row to the left (This is the title or label of the expression row, not the value of the row). Im trying not to colour this cell and only colour the cell values. This is my code for the background colour on the expression.

if(((column(3)- column(4))<= -0.10),rgb(199,255,193),

if(((column(3)- column(4))> -0.10 and (column(3)- column(4))<=0),rgb(0,127,0),

   if(((column(3)- column(4))>0 and (column(3)- column(4))<=0.049),rgb(215,180,40),

    if((column(3)- column(4))>=0.05,rgb(255,0,0)

  ))))

Can anyone help

Kind regards

Martin

[#2]

NOTE:

I dont think i can use visual cubes as this will only allow 3 colours, thanks

Martin

[lironbaram]

you can try to add if rowno()>0,

so it'll look like

if(rowno()>0,

if(((column(3)- column(4))<= -0.10),rgb(199,255,193),

if(((column(3)- column(4))> -0.10 and (column(3)- column(4))<=0),rgb(0,127,0),

if(((column(3)- column(4))>0 and (column(3)- column(4))<=0.049),rgb(215,180,40),

if((column(3)- column(4))>=0.05,rgb(255,0,0)

)))))

[#4]

Hi

That was nearly correct and i'm getting warmer thank , but one of my values goes into a minus and the whole row gets coloured in white... have you any other ideas as im trying to look for negative values too..

Thanks

[lironbaram]

can you post sample data i dont understand on what minus you are talikng

[#6]

have a look. When a value goes into a minus then all goes white. 

Im testing using the following code, but it still does not make the label column (far left) white or any other different colour. Ive left out the label value on the screem print for confidentiality, thanks

Martin

[lironbaram]

i if i ynderstood corectly then i your case try to switch rowno with columnno

[#8]

Hi

Thanks for your reply. Ive tried column and row number and the same still appears to happen. I'm guessing its a qlikview as ive searched all over and no one seems to know, thanks

Martin