topic Re: IF AND Color Expression in QlikView

IF AND Color Expression

simongoodman — Mon, 01 Apr 2013 11:57:39 GMT

I have a pivot table and I am trying to create an if statement with the Background Color of an expression where a value triggers a RGB color.

My problem is one set of values is greater then say 60% but less then 80% so it then applies a RGB. I have tried a number of IF AND expressions but I can not get it to work, very frustrating for what should be a simple if statement. Can any one help?

Re: IF AND Color Expression

sushil353 — Mon, 01 Apr 2013 12:01:36 GMT

please find attached.

HTH

Sushil

Re: IF AND Color Expression

simongoodman — Mon, 01 Apr 2013 14:08:35 GMT

Hi Sushil, that worked a treat, (though oddly I had tried a similar expression) so thanks.

I have another question my pivot table has 2 dimensions, a horizontal MthYr and a vertical SectorType. The SectorType has the 'Show Parial Sum' ticked in Presentation but the Total does not respond to color expression, any ideas why?

Simon

Re: IF AND Color Expression

sushil353 — Tue, 02 Apr 2013 04:59:43 GMT

hi,

do u have any sample application to post...

HTH

Sushil

Re: IF AND Color Expression

simongoodman — Tue, 02 Apr 2013 09:41:55 GMT

Hi Sushil,

The attached qvw shows;

1. A table with my expression where the TOTAL does not respond to the if

color condition.

2. A table with a version of your expression where TOTAL only returns Green

no matter what condition is met.

Simon

Re: IF AND Color Expression

sushil353 — Tue, 02 Apr 2013 10:16:42 GMT

ok... thats true...

what is your requirement now.?

Re: IF AND Color Expression

simongoodman — Tue, 02 Apr 2013 10:22:38 GMT

I was trying to get both the Sector Dimension data and the TOTAL by

MonthYr to respond correctly to the IF Color Conditions.

Re: IF AND Color Expression

sushil353 — Tue, 02 Apr 2013 10:25:58 GMT

it is responding to the if condition.. try to change the condition in if condition it will change accordingly..

the problem here is in the total it is satisfying the if condition to have the green color.

see the attached file and in main tab

HTH

Sushil

Re: IF AND Color Expression

simongoodman — Tue, 02 Apr 2013 10:58:39 GMT

Thanks right now I can not see how to change/add into the condition to get

TOTAL to respond correctly.