topic Pivot table background colour problem in QlikView

Pivot table background colour problem

Tue, 17 Apr 2012 08:42:11 GMT

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

Pivot table background colour problem

Tue, 17 Apr 2012 08:44:12 GMT

NOTE:

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

Martin

Pivot table background colour problem

lironbaram — Tue, 17 Apr 2012 08:46:37 GMT

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)

)))))

Pivot table background colour problem

Tue, 17 Apr 2012 09:12:30 GMT

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

Pivot table background colour problem

lironbaram — Tue, 17 Apr 2012 10:17:07 GMT

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

Pivot table background colour problem

Tue, 17 Apr 2012 10:34:50 GMT

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

Pivot table background colour problem

lironbaram — Tue, 17 Apr 2012 10:53:45 GMT

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

Pivot table background colour problem

Tue, 17 Apr 2012 11:16:43 GMT

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