topic Re: If logic consolidation in QlikView

If logic consolidation

dhanu_today — Fri, 11 Apr 2014 11:22:11 GMT

Hi Everyone,

I have to get the list of customers with the below conditions and same has to do in design level.

Req:

1)) Product Codes - 883,887,903,945,946,939
2) Promotion Code - AbcOC1, CbaB01, DcdENC, EzcC01, SoaIE1, SYTEDU, TwuS01, TRUS02, WaeFAR1, SECT25, Gae000
3) Customer Type – ‘Newone’.

Along with above conditions, we need to consider those customers who are having CASA accounts as per logic but having Customer Type not equal to 'Newone’ under FD Product.

Dimension level I wrote the below logics individually how we can consolidate both logics as one to fill the above req. We no need to consider the Cust_id’s which are having product as FD and Customer_type not equal to ‘Newone’ in the second script.(it’s the difference between both the logics)

=if(wildmatch(PRODUCT_CODE,'883','887','903','945','946','939') and wildmatch(PROMO_CODE,'AbcOC1', 'CbaB01', 'DcdENC', 'EzcC01', 'SoaIE1',
'SYTEDU', 'TwuS01', 'TRUS02', 'WaeFAR1', 'SECT25', 'Gae000') and wildmatch(CUSTOMER_TYPE,'Newone’) and WILDMATCH (PRODUCT,'CA',’SA’),CUST_ID)

=if(wildmatch(PRODUCT_CODE,'883','887','903','945','946','939') and wildmatch(PROMO_CODE,'AbcOC1', 'CbaB01', 'DcdENC', 'EzcC01', 'SoaIE1',
'SYTEDU', 'TwuS01', 'TRUS02', 'WaeFAR1', 'SECT25', 'Gae000') and not wildmatch(CUSTOMER_TYPE,'Newone’) AND WILDMATCH (PRODUCT,'FD'),CUST_ID)

Let me know if in case any clarifications and unable to attache the sample app.

Thanks Inadvance,

Dhanu

Re: If logic consolidation

Gysbert_Wassenaar — Fri, 11 Apr 2014 11:36:59 GMT

Try:

=if(wildmatch(PRODUCT_CODE,'883','887','903','945','946','939') and wildmatch(PROMO_CODE,'AbcOC1', 'CbaB01', 'DcdENC', 'EzcC01', 'SoaIE1',

'SYTEDU', 'TwuS01', 'TRUS02', 'WaeFAR1', 'SECT25', 'Gae000') and

((wildmatch(CUSTOMER_TYPE,'Newone’) and WILDMATCH (PRODUCT,'CA',’SA’)) or (not wildmatch(CUSTOMER_TYPE,'Newone’) and WILDMATCH (PRODUCT,'FD')) ) ,CUST_ID)

Note, if these are all fields from the same table, you could consider creating a flag field in the script to mark these customers and use the flag field to select them. Or you could create bookmarks for both sets and use the bookmarks in set analysis expressions.

Re: If logic consolidation

dhanu_today — Fri, 11 Apr 2014 14:01:56 GMT

Thanks Gysbert ..Its working..Small correction in my query.

I have the Product category as ‘CA’,’SA’,’FD’.

A)To calculate the CASA customers we have consider the conditions below.

1)) Product Codes - 883,887,903,945,946,939
2) Promotion Code - AbcOC1, CbaB01, DcdENC, EzcC01, SoaIE1, SYTEDU, TwuS01, TRUS02, WaeFAR1, SECT25, Gae000
3) Customer Type – ‘Newone’.

B)To calculate the FD customers we have consider the conditions below.

Customer Type – ‘Newone’.

C)To calculate the CASA_FD customers we have consider the conditions below.

Let say if I have 100 FD customers(from B) with the CUSTOMER_TYEPE as ‘Newone’ and from the 100 custid’s We have check whether they are having CASA product or not with CUSTOMER_TYEPE is not equal to ‘Newone’.If yes we have to show that information also.

It means in domain level one custid having multiple products.We have to capture the customers details by various parameters.

Let me know if in case of any clarifications.

Thanks,

Dhanu

Re: If logic consolidation

dhanu_today — Fri, 11 Apr 2014 17:04:02 GMT

Hi Any hint from anyone..

Thanks,

Dhanu