Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot table background colour problem

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

7 Replies
Not applicable

Pivot table background colour problem

NOTE:

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

Martin

lironbaram
Honored Contributor II

Pivot table background colour problem

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)

)))))

Not applicable

Pivot table background colour problem

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
Honored Contributor II

Pivot table background colour problem

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

Not applicable

Pivot table background colour problem

example data.bmp

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
Honored Contributor II

Pivot table background colour problem

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

Not applicable

Pivot table background colour problem

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

Community Browser