topic Re: IF + AND in QlikView

IF + AND

Anonymous — Tue, 30 Aug 2011 01:55:20 GMT

How do I combine these two exepressions:

= IF (Wildmatch(address_number, '9*'), 'Not In Service', 'In Service')

= IF (Wildmatch(individual_item_number, 'PRIN*), 'Not Installed', 'Installed')

Into IF both conditions , (Not in Service and Not Installed) 'Not Active', 'Active' ?

(I do not need to keep either of the original expressions, but they both work alone)

Thanks a bunch, JL

nagaiank — Tue, 30 Aug 2011 04:32:30 GMT

The following script works. There may be other ways of doing this also.

LOAD *,

If(WildMatch(address_number, '9*')=1, 'Not In Service', 'In Service') as [In Service],

If(WildMatch(individual_item_number,'PRIN*')=1,'Not Installed','Installed') as Installed,

If((WildMatch(address_number, '9*')=1) and (WildMatch(individual_item_number,'PRIN*')=1),'Not Active', 'Active') as Active;

LOAD * Inline [

address_number, individual_item_number

1234, ABCD123

9876, ABC2345

2345, PRIN123

9765, PRIN345

];

Anonymous — Tue, 30 Aug 2011 13:24:22 GMT

Thnaks - I put it in the load script. Works great!

Jonathan