Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background color in a pivot table expression label problem

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

4 Replies
pover
Luminary Alumni
Luminary Alumni

Martin,

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

Karl

Not applicable
Author

thanks for that Karl...

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

Thanks

leocvaz
Contributor III
Contributor III

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

Not applicable
Author

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

© 1993-2011 QlikTech International AB     Copyright & Trademarks | Privacy | Terms of Use | Software EULA