topic Re: Nested IF Statement Help in QlikView

Nested IF Statement Help

Fri, 06 Nov 2015 12:55:40 GMT

Hi,

I am having trouble with a nested IF statement;

I'm getting an error of "Error in expression, if takes 2-3 parameters"

The query below has 2 clear statements and an alternative outcome so I'm not sure why this fails. Can someone advise where I am going wrong?

=IF((Team = 'West Ham' and Result = 'Home Win' and IsHomeTeam = 'Yes')
OR (Team = 'West Ham' and Result = 'Away Win' and IsHomeTeam = 'No'),'W',
IF(Team = 'West Ham' and Result = 'Draw'),'D',
'L')

Re: Nested IF Statement Help

alexandros17 — Fri, 06 Nov 2015 13:04:58 GMT

Try with

=IF((Team = 'West Ham' and Result = 'Home Win' and IsHomeTeam = 'Yes')
OR (Team = 'West Ham' and Result = 'Away Win' and IsHomeTeam = 'No'),'W',
IF(Team = 'West Ham' and Result = 'Draw','D',
'L') )

let me know

Re: Nested IF Statement Help

maxgro — Fri, 06 Nov 2015 13:12:41 GMT

IF( (Team = 'West Ham' and Result = 'Home Win' and IsHomeTeam = 'Yes') OR (Team = 'West Ham' and Result = 'Away Win' and IsHomeTeam = 'No'), 'W',

IF( (Team = 'West Ham' and Result = 'Draw' ), 'D',

'L'))

Re: Nested IF Statement Help

Anonymous — Fri, 06 Nov 2015 13:16:47 GMT

Try this:

Misiing brackets..

=IF(((Team = 'West Ham' and Result = 'Home Win' and IsHomeTeam = 'Yes')

OR (Team = 'West Ham' and Result = 'Away Win' and IsHomeTeam = 'No')),'W',
IF((Team = 'West Ham' and Result = 'Draw'),'D','L'))

Re: Nested IF Statement Help

Fri, 06 Nov 2015 13:33:01 GMT

Many thanks guys, it's always a missing bracket!

Can you advise now this IF statement works how I would use the Visual Cues to make the expression background Green for a W, Red for an L and Grey for a D?

Re: Nested IF Statement Help

Anonymous — Fri, 06 Nov 2015 14:08:43 GMT

Go to Visual Cues of your reports object

and set the color like Text/Backgroud etc..

PFA

Re: Nested IF Statement Help

Anonymous — Fri, 06 Nov 2015 14:09:53 GMT

Select your expression name in you Visual Cues properties of Reports from top left,

and apply cues as per ur reqs..

Re: Nested IF Statement Help

Fri, 06 Nov 2015 14:15:06 GMT

I've set the following up, but it does not work?