If Logic help

dhanu_today — Wed, 16 Apr 2014 14:05:40 GMT

Hi Everyone,

I have the fileds CUST_ID,PRODUCT,CUSTOMER_TYPE,P_CODE and PD_CODE.

How can I get the list of CUST_ID’s based on the below parameters.

1) IF(WildMatch(P_CODE,'883','887','903','945','946','939') or WILDMATCH(PD_CODE,'ASSOC1', 'CLUB01', 'DEFENC', 'EDUC01', 'SOCIE1', 'SYTEDU', 'TRUS01', 'TRUS02', 'WELFAR1', 'SECT25', 'GRM000')
or WILDMATCH(CUSTOMER_TYPE,'ASSOCIATION/ TRUSTS')

AND WILDMATCH(PRODUCT,'CA','SA') ,CUST_ID) AS CASA_BASE, (TO GET THE COUNT UNDER PRODUCT CASA CATEGORY)
2) IF( WILDMATCH(CUSTOMER_TYPE,'ASSOCIATION/ TRUSTS') AND WILDMATCH(PRODUCT,'FD'),CUST_ID) AS FD_BASE (TO GET THE COUNT UNDER PRODUCT FD CATEGORY)

3)In the third condition we have avoid the CUST_ID’s which contains CUSTOMER_TYPE as 'ASSOCIATION/ TRUSTS' under the PRODUCT ‘FD’

How we can can merge the logic(1 and 2) to fill the third conditin.

Let me know if in case of any clarifications.

Thanks in adv,

Dhanu

Re: If Logic help

bbi_mba_76 — Wed, 16 Apr 2014 14:09:03 GMT

Hi,

maybe you can add some flag fields to the script and use those flags in the expressions.

Re: If Logic help

dhanu_today — Wed, 16 Apr 2014 14:19:24 GMT

Thanks BBI..But Need help in the way to do that !!

Re: If Logic help

dhanu_today — Wed, 16 Apr 2014 14:54:51 GMT

Hi any hint from experts.Its a little bit urgent. Thanks, Dhanu

topic Re: If Logic help in QlikView

If Logic help

Re: If Logic help

Re: If Logic help

Re: If Logic help