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

Expression paint spill!

Hello,

Hope someone can help with this tiny design query

I have a pivot table with multiple condition background color expression - (ie if the value satisfies condition 1 paint it green, if condition 2 paint it red etc.). As you can see below it colours the values correctly, but what it also does is paint the background of the actual label "Solvency Ratio" with one of the gradients?

Is there a way to prevent this from happening?

ratio colour.png

Regards
Marek

11 Replies
its_anandrjs

Write like

Click on + in the expression and in background property write like

If(Yourexpression >= 10% and Yourexpression <= 90%,Red(),Green())

Some thing like in the expression background

lukaspuschner
Partner - Creator
Partner - Creator

could you attatch the file?

MK_QSL
MVP
MVP

Use as below in your expression

IF(Dimensionality()<>0, YourExpressionForColor)

Something like below

IF(Dimensionality()<>0,IF(SUM(Sales)<100,Red(),

  IF(SUM(Sales)<150,Green(),

  Blue())))

Not applicable
Author

Hi,

You can try something like this:

         if( RowNo()>0,

                  (   if(Sum(Sales)=1000,Red(),Blue())  )

         )

ThornOfCrowns
Specialist II
Specialist II

You may want to look at the DIMENSIONALITY function. You can use it to exclude parts of the table by using something like If(Dimentionality()>0...)

swuehl
MVP
MVP

Have a look at this discussion:

Background color of Pivot Table Labels

ThornOfCrowns
Specialist II
Specialist II

Hi Swuehl,

that discussion is long and old and also doesn't come to a resolution, so may not be the most helpful thing to read.

Regards,

James.

swuehl
MVP
MVP

I think the issue described is still valid to the current situation.

And Matt's workaround described in the referenced thread might help (or maybe not, that's up to the OP's situation).

ThornOfCrowns
Specialist II
Specialist II

I see what you're saying. I would still suggest that the Dimentionality fix works better than using Visual Cues...