topic Re: Match Logic in QlikView

Match Logic

tmumaw — Mon, 11 Dec 2017 18:52:52 GMT

Should this not work?

Thanks

if(Match(Opportunity.davey_HeaderCancelCode,'05','06','18','22','24','25','27') > 0,1,0) as HPermCancel,

Re: Match Logic

m_woolf — Mon, 11 Dec 2017 18:59:52 GMT

Looks OK to me. What are the possible values for Opportunity.davey_HeaderCancelCode and what are you getting for HPermCancel?

Re: Match Logic

mdmukramali — Mon, 11 Dec 2017 19:00:16 GMT

Hi,

can you try like below.

if(Match(Opportunity.davey_HeaderCancelCode,'05','06','18','22','24','25','27') ,1,0) as HPermCancel,

if(WlidMatch(Opportunity.davey_HeaderCancelCode,'05','06','18','22','24','25','27') ,1,0) as HPermCancel,

Thanks,

Mukram

Re: Match Logic

sunny_talwar — Mon, 11 Dec 2017 19:00:54 GMT

It seems like it should work... basically you are assigning 1 for all those rows where Opportunuty.dabey_HeaderCancelCode = 05, 06, 18, 22, 24, 25, 27, right?

Re: Match Logic

tmumaw — Mon, 11 Dec 2017 19:05:22 GMT

Yep

Re: Match Logic

sunny_talwar — Mon, 11 Dec 2017 19:18:03 GMT

Don't see a reason for it to not work.... Is it not flagging anything with 1? or everything is flagged with 1? What is going on?

Re: Match Logic

tmumaw — Mon, 11 Dec 2017 19:20:27 GMT

I am running it again to see what is flagged and what is not. Will keep you posted thanks.

Re: Match Logic

tmumaw — Mon, 11 Dec 2017 20:11:19 GMT

My test did not work.....any ideas....

Re: Match Logic

sunny_talwar — Mon, 11 Dec 2017 20:14:57 GMT

What were the results? Without giving me more details, I would be throwing stones in the dark...

Re: Match Logic

tmumaw — Mon, 11 Dec 2017 20:22:25 GMT

I am reading 2 different databases (Microsoft CRM and SAP) one is storing it differently than the other. I will re-run in the morning and let you know the results. Need to make a few changes and re-extract the data. Thanks

Re: Match Logic

tmumaw — Tue, 12 Dec 2017 12:53:29 GMT

Found the problem. CRM stored them without the leading 0 and SAP with the leading 0. Resolved.