topic Re: Expression paint spill! in QlikView

Expression paint spill!

Fri, 02 May 2014 09:26:22 GMT

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?

Regards
Marek

Re: Expression paint spill!

its_anandrjs — Fri, 02 May 2014 09:29:39 GMT

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

Re: Expression paint spill!

lukaspuschner — Fri, 02 May 2014 09:30:43 GMT

could you attatch the file?

Re: Expression paint spill!

MK_QSL — Fri, 02 May 2014 09:33:27 GMT

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())))

Re: Expression paint spill!

Fri, 02 May 2014 09:34:32 GMT

Hi,

You can try something like this:

if( RowNo()>0,

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

)

Re: Expression paint spill!

ThornOfCrowns — Fri, 02 May 2014 09:35:46 GMT

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...)

Re: Expression paint spill!

swuehl — Fri, 02 May 2014 09:42:39 GMT

Have a look at this discussion:

Background color of Pivot Table Labels

Re: Expression paint spill!

ThornOfCrowns — Fri, 02 May 2014 09:59:46 GMT

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.

Re: Expression paint spill!

swuehl — Fri, 02 May 2014 10:05:17 GMT

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).

Re: Expression paint spill!

ThornOfCrowns — Fri, 02 May 2014 10:42:21 GMT

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

Re: Expression paint spill!

Fri, 02 May 2014 15:44:58 GMT

hi guys,

Thank you for your suggestions, I have went through the other post but nothing seems to work for a pivot table.

The only way I got my table to "work" without having the label change colour, is turn it into a "straight" one

Re: Expression paint spill!

giakoum — Fri, 02 May 2014 15:49:57 GMT

or maybe create a fake dimension, displaying nothing in the label. This fake dimension will get the color and your normal dimension will not