topic Re: Background color in a pivot table expression label problem in QlikView

Background color in a pivot table expression label problem

Wed, 28 Mar 2012 15:41:00 GMT

Has anyone been able to solve the issue of the background colour that shows up in the expression label.

This colour is the same as the column on the left of the pivot table.

my code as follows:

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)

))))

I have 7 columns as expressions which are shown on the left of the pivot table

and one dimension showing on the top.

the very last expression is highlighted as per the color expression above but this also highlights the

expression label column which is labeled 'RAG % Diff'

Ive also tried to used Dimensionality() =0 and rownno() = 0 and changing the to 1 to see what the results are but

still no joy.

I could use visual cues, but i need to have 4 colours.

Kind regards

Martin

Background color in a pivot table expression label problem

pover — Wed, 28 Mar 2012 18:14:29 GMT

Martin,

This is still a problem in QV 11. I haven't found a good way to get around it yet.

Karl

Background color in a pivot table expression label problem

Thu, 29 Mar 2012 07:26:04 GMT

thanks for that Karl...

My solution may be to add another dimension and hide the coloured column.

Thanks

Re: Background color in a pivot table expression label problem

leocvaz — Fri, 23 Nov 2012 13:05:30 GMT

Hi,

I had the same problem. I made a workaround that worked in my case.

- In presentation put the sub total on top

- in the backgroud color of the expression test the dimensionality (do not color the subtotal)

The subtotal row works like a barrier for the colored cells.

bye

Re: Background color in a pivot table expression label problem

Fri, 23 Nov 2012 18:23:02 GMT

fantastic ..... thanks

Sent from Martins Samsung Mobileleocvaz <qcwebmaster@qlik.com> wrote:QlikCommunity

Re: Background color in a pivot table expression label problem

created by leocvaz in Development (QlikView Desktop) - View the full discussion

Hi,

I had the same problem. I made a workaround that worked in my case.

- In presentation put the sub total on top

- in the backgroud color of the expression test the dimensionality (do not color the subtotal)

The subtotal row works like a barrier for the colored cells.

bye

Reply to this message by replying to this email -or- go to the message on QlikCommunity

Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity