topic Re: If Logic problem in QlikView

If Logic problem

dhanu_today — Fri, 18 Apr 2014 17:24:29 GMT

Hi everyone,

I need some help in the below script and attached the data and application as well.

In CASA+FD table the PRODUCT CA (second row) is not satisfing the CASA LOGIC.

WildMatch(PRODUCT_CODE,'200','201','202','203','204')

or WILDMATCH(PROMO_CODE,'300','301','302','303','304')

or WILDMATCH(TYPE,'Associate') AND WILDMATCH(PRODUCT,'CA','SA') ;

The above script is working fine in CASA field but giving some wrong value in CASA+FD.(Here we will get the list of CUST_IDS

under the PRODUCT FD with TYPE not equal to 'ASSOCIATE'.

(Purpose is to get the list of CUSTID'S which are having FD product with TYPE not equal to 'ASSOCIATE')

Thanks in advance,

Dhanu

Re: If Logic problem

santharubban — Fri, 18 Apr 2014 17:41:56 GMT

hi,

Use this expression in the CASA+FD table

only({<PRODUCT = {'FD'},TYPE -={'Associate'}>} CUST_ID)

i think it will help you.

Re: If Logic problem

dhanu_today — Fri, 18 Apr 2014 17:46:18 GMT

Thanks Ks..But its not working as per above.It is giving only FD custids'

Dhanu

Re: If Logic problem

dhanu_today — Fri, 18 Apr 2014 18:06:30 GMT

Any hint from any one !!

Thanks

Dhanu

Re: If Logic problem

santharubban — Fri, 18 Apr 2014 18:07:46 GMT

you have mentioned

(Purpose is to get the list of CUSTID'S which are having FD product with TYPE not equal to 'ASSOCIATE')

you need only FD product except 'ASSOCIATE' right.

Re: If Logic problem

dhanu_today — Fri, 18 Apr 2014 18:13:50 GMT

Yes that is right....that mentined condition + casa logic also.

In short, whatever the custid's am getting for the ids i have to get the fd relation with except type 'associate'

Please check once the application.

Thanks,

dhanu

Re: Re: If Logic problem

Fri, 18 Apr 2014 19:51:23 GMT

Hey Dhanu,

I am not sure why you are creating another table in your script. You can just create flags in the original table itself for whatever condition thats required.

Check out the attached and see if it helps. I created two flags on the backend. If condition is met it will be 1 else 0.

Thanks

Re: If Logic problem

dhanu_today — Sat, 19 Apr 2014 04:35:47 GMT

Thanks Aj...The first 2 logics you have mentioned that are working fine in earlier also.

But the problem at 3 logic level.Let me explain in detail.

The CASA CUSTID'S(as per first logic) may have the product FD also.(which are not equal to TYPE ASSOCIATE).

Wrong record is below. which is not coming in CASA(Logic1) thats correct..But it is coming in CASA+FD.its wrong.

8011

606

456

Deliver

I have to get those custids in script level to do the some further calculations in front end like Count(CASA),count(FD) and Count(CASA+FD).

Let me know if in case of any clarificatin

Thanks,

Dhanu

Re: If Logic problem

dhanu_today — Sat, 19 Apr 2014 08:39:18 GMT

Any hint from any one or any alternate method to get the mentioned above req.

Thanks,

Dhanu

Re: If Logic problem

Sat, 19 Apr 2014 13:29:17 GMT

But if you look at the FD_Flag in my qvw file for

8011

606

456

Deliver

it will be 0 which means it doesn't satisfy the condition. So on you front end calculations you can use set analysis like

Count({<FD_Flag = {1} >} Cust_ID)

Then the above record won't even be considered in the calculation.

Does that make sense?

Thanks

Re: If Logic problem

dhanu_today — Mon, 21 Apr 2014 10:36:16 GMT

Thanks Aj.The logics you have mentioned for the individual counts of FD and CASA are correct.

But final level CASA_Flag custids we have to check CASA CUSTID'S are having any FD relation with TYPE <> 'Associate' under the product FD.It means only FD relation with TYPE <> 'Associate' under the product FD custids are no need to consider.We have to consider when they have CASA relation also.

Thanks,

Dhanu

Re: If Logic problem

nilesh_gangurde — Mon, 21 Apr 2014 12:43:29 GMT

PFA

-Nilesh

Re: If Logic problem

dhanu_today — Wed, 23 Apr 2014 16:37:24 GMT

Thanks Nilesh G...Its working fine.

Dhanu