topic Re: Logic Issue in QlikView

Logic Issue

tmumaw — Mon, 22 Aug 2016 14:35:44 GMT

Can someone please help me with this logic. I have 2 fields I am checking. Both fields are blank and it's coming back with a mismatch. I have tried If(isnull(Davey_NextRenewalPODNP) and (len(NRC_SAP) = 0),0

Thanks

if(isnull(davey_NextRenewalPODNP) and (Len(NRC_SAP) > 0),1,
if(isnull(davey_NextRenewalPODNP) and isnull(NRC_SAP),0,
if(NRC_SAP <> davey_NextRenewalPODNP,1,0))) as NoMatchNRC,

Re: Logic Issue

sunny_talwar — Mon, 22 Aug 2016 14:39:59 GMT

So you are facing a issue here?

if(NRC_SAP <> davey_NextRenewalPODNP,1,0)

Re: Logic Issue

tmumaw — Mon, 22 Aug 2016 14:41:24 GMT

No. It's when they are both blank.

Thanks

Re: Logic Issue

sunny_talwar — Mon, 22 Aug 2016 14:43:44 GMT

Can you check using Len(Trim()) instead of IsNull()

If(Len(Trim(davey_NextRenewalPODNP)) = 0 and Len(Trim(NRC_SAP)) > 0, 1,
If(Len(Trim(davey_NextRenewalPODNP)) = 0 and Len(Trim(NRC_SAP)) = 0, 0,
If(NRC_SAP <> davey_NextRenewalPODNP, 1, 0))) asNoMatchNRC,

Re: Logic Issue

dominicmander — Mon, 22 Aug 2016 14:55:10 GMT

Hi Thom,

As a test, try Ord() of both fields ... it could be that there is a "blank" character Chr(0) ... which is a character for a blank so fails the IsNull() and Len() tests.

Re: Logic Issue

tmumaw — Mon, 22 Aug 2016 15:03:10 GMT

Thanks Sunny T.....

Re: Logic Issue

sunny_talwar — Mon, 22 Aug 2016 15:04:33 GMT

No problem