Discussion Board for collaboration related to QlikView App Development.
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),
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.
This is still a problem in QV 11. I haven't found a good way to get around it yet.
thanks for that Karl...
My solution may be to add another dimension and hide the coloured column.
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.
fantastic ..... thanks
Sent from Martins Samsung Mobileleocvaz <firstname.lastname@example.org> wrote:QlikCommunity
Re: Background color in a pivot table expression label problem
created by leocvaz in Development (QlikView Desktop) - View the full discussion
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