topic Re: Errors with Red and Green background for if statement in QlikView

Errors with Red and Green background for if statement

stjernvd — Tue, 29 Sep 2015 10:53:49 GMT

Hi,

Depending on my if statement I would like a red and green background for the values, but when I use this equation it doesn't work, I am using this statement in the background drop down in the expressions tab in a straight table...

if(Match([Tool Entity],'Eduroam','Lse')=0,Green(),if(Match([Tool Entity],'Eduroam','Lse')<>0,Red()))

So I want for the values for fields 'Eduroam' and 'Lse' within the main field [Tool Entity] to be green when = 0 and I want them to be red when they are not equal to 0.

What am I doing wrong?

Re: Errors with Red and Green background for if statement

simenkg — Tue, 29 Sep 2015 10:56:10 GMT

Pick(1+Match([Tool Entity],'Eduroam','Lse'),Red(),Green(),Green())

Re: Errors with Red and Green background for if statement

avinashelite — Tue, 29 Sep 2015 10:58:46 GMT

try like this:

if([Tool Entity]='Eduroam' or [Tool Entity]='Lse',Green(),Red())

Re: Errors with Red and Green background for if statement

avinashelite — Tue, 29 Sep 2015 10:59:36 GMT

Re: Errors with Red and Green background for if statement

Gysbert_Wassenaar — Tue, 29 Sep 2015 11:01:29 GMT

So I want for the values for fields 'Eduroam' and 'Lse' within the main field [Tool Entity] to be green when = 0 and I want them to be red when they are not equal to 0.

Ehm... a string value 'Eduroam' is always unequal to a value 0. 'Eduroam' is a string value. Where does the 0 come from?

Re: Errors with Red and Green background for if statement

stjernvd — Tue, 29 Sep 2015 11:02:05 GMT

Hi Simen,

Thank you for this.

How do I do it so that only the value is green or red and not the entire background? so just the number?

Re: Errors with Red and Green background for if statement

stjernvd — Tue, 29 Sep 2015 11:05:18 GMT

Hi Gysbert,

Sorry I clearly made a mistake, these fields 'Eduroam' and 'Lse' are meant to be for the sum(position) column which is the values of the fields 'Eduroam' and 'Lse' within 'Tool Entity'.

So when 'Eduroam' and 'Lse' within TOOL ENTITY = 0, the values for sum(position) should be green, and if they are not equal to zero sum(position) values should be red.

How do I set that up?

Re: Errors with Red and Green background for if statement

stjernvd — Tue, 29 Sep 2015 11:07:14 GMT

Hi Avinash,

Sorry I clearly made a mistake, these fields 'Eduroam' and 'Lse' are meant to be for the sum(position) column which is the values of the fields 'Eduroam' and 'Lse' within 'Tool Entity'.

So when 'Eduroam' and 'Lse' within TOOL ENTITY = 0, the values for sum(position) should be green, and if they are not equal to zero sum(position) values should be red.

How do I set that up?

Re: Errors with Red and Green background for if statement

Gysbert_Wassenaar — Tue, 29 Sep 2015 11:09:11 GMT

I'm afraid you're not making things clearer. I have no idea what are fields, what are expressions and what are values. Please post a small qlikview document that makes clear what's what.

Re: Errors with Red and Green background for if statement

stjernvd — Tue, 29 Sep 2015 11:14:56 GMT

Sorry, in my straight table:

Tool Entity (Field)

Eduroam

LSE

UCL

Kings

Sum(Position) (Values)

So I only want to highlight the strings 'Eduroam' and 'Lse' as red and green within the field Tool Entity, so if sum(Position) for Eduroam and Lse = 0, I want the Sum(Position) value to be green, if sum(Position) for Eduroam and Lse <> 0, I want the Sum(Position) value to be red. I just want to highlight the number, not the entire cell background.

How do I do this?

Re: Errors with Red and Green background for if statement

Tue, 29 Sep 2015 11:18:24 GMT

stjernvd,

try something like:

IF( ( [Tool Entity]='Eduroam' OR [Tool Entity]='Lse' ) AND SUM(Sales) <> 0 , Green(), IF( ( [Tool Entity]='Eduroam' OR [Tool Entity]='Lse' ) AND SUM(Sales) <> 0 ,Red()))

Marc

Re: Errors with Red and Green background for if statement

Gysbert_Wassenaar — Tue, 29 Sep 2015 12:59:43 GMT

Maybe like this: If(match([Tool Entity],'Eduroam','LSE', if(sum(Position), red(), green() )). You will have to disable the Suppress Zero-Values option. Otherwise records where sum(Position) is 0 won't be shown.