topic Dual If Statements in QlikView

Dual If Statements

Anonymous — Mon, 16 Jun 2014 13:18:15 GMT

Hello,

I am new to the coding and working on an If statement that has an additional condition in the False position that is meant to narrow the selections for Brooder down to 17.

Here is what I have and the opposite of CONVENTIONAL is OFFSITE if this matters. My expression is marked as ok, but it only returns a -1 for the result instead of the names that are listed.

IF(Housing = 'CONVENTIONAL',Grower_Name,
Brooder = 'BURNEY BROODER'
OR Brooder = 'CC ROAD FARM'
OR Brooder = 'C&C QUICK TURN'
OR Brooder = 'C&D BROODER'
OR Brooder = 'DKC BROODER'
OR Brooder = 'HONEYCUTT FAMILY BROODER HUB'
OR Brooder = 'HUDSON BROODER'
OR Brooder = 'J & K BLACKMON BROODER'
OR Brooder = 'KIMS BROODER HUB'
OR Brooder = 'L&C BROODER'
OR Brooder = 'MAGUIRES BROODER FARM'
OR Brooder = 'R&S BROODER'
OR Brooder = 'RANDY SMITH BROODER HUB'
OR Brooder = 'S & A TANNER BROODERS'
OR Brooder = 'WAYNE SMITH'
OR Brooder = 'WILSON FAMILY BROODER HUB'
OR Brooder = 'WINDY CREEK BROODER FARM')

Any help you can offer will be greatly appreciated.

Thanks,

Bradley Faircloth

Re: Dual If Statements

MK_QSL — Mon, 16 Jun 2014 13:22:02 GMT

What you want to achieve?

Re: Dual If Statements

CELAMBARASAN — Mon, 16 Jun 2014 13:25:08 GMT

May be something like this

IF(Housing = 'CONVENTIONAL',Grower_Name,
IF(Brooder = 'BURNEY BROODER'
OR Brooder = 'CC ROAD FARM'
OR Brooder = 'C&C QUICK TURN'
OR Brooder = 'C&D BROODER'
OR Brooder = 'DKC BROODER'
OR Brooder = 'HONEYCUTT FAMILY BROODER HUB'
OR Brooder = 'HUDSON BROODER'
OR Brooder = 'J & K BLACKMON BROODER'
OR Brooder = 'KIMS BROODER HUB'
OR Brooder = 'L&C BROODER'
OR Brooder = 'MAGUIRES BROODER FARM'
OR Brooder = 'R&S BROODER'
OR Brooder = 'RANDY SMITH BROODER HUB'
OR Brooder = 'S & A TANNER BROODERS'
OR Brooder = 'WAYNE SMITH'
OR Brooder = 'WILSON FAMILY BROODER HUB'
OR Brooder = 'WINDY CREEK BROODER FARM', Brooder ))

Re: Dual If Statements

Anonymous — Mon, 16 Jun 2014 13:30:14 GMT

That's it, I wasn't putting the extra Brooder at the end of the coding.

Thanks for your help.

Re: Dual If Statements

jerem1234 — Mon, 16 Jun 2014 13:44:12 GMT

Just as an addition, you might be able to reduce your code a bit with the match function (so you don't need the extra OR's and 'Brooder ='s, like:

IF(Housing = 'CONVENTIONAL',Grower_Name,
IF(Match(Brooder, 'BURNEY BROODER', 'CC ROAD FARM', 'C&C QUICK TURN',

'C&D BROODER', 'DKC BROODER', 'HONEYCUTT FAMILY BROODER HUB',

'HUDSON BROODER', 'J & K BLACKMON BROODER', 'KIMS BROODER HUB',

'L&C BROODER', 'MAGUIRES BROODER FARM', 'R&S BROODER', 'RANDY SMITH BROODER HUB',

'S & A TANNER BROODERS', 'WAYNE SMITH', 'WILSON FAMILY BROODER HUB',

'WINDY CREEK BROODER FARM'), Brooder))

Hope this helps!

Re: Dual If Statements

Anonymous — Mon, 16 Jun 2014 14:03:51 GMT

Thanks, I will keep that in mind.