topic Re: Eliminating too many record?? in QlikView

Eliminating too many record??

Thu, 07 Aug 2014 20:35:36 GMT

$(qvd_name)

load
[Loan Number],
[Loss Mit Status Code],
[Servicing Sold Id],
[Referral Code]
FROM
(qvd)
where
[Loss Mit Status Code] = 'A'
and not Match([Servicing Sold Id],'NSM120110'); /*I am only trying to eliminate records having this Servicing Sold ID here. Instead I seem to eliminate far more. When I comment out this line of code I get 4000 records. When I include this code I only get about 147 records. Any ideas why?*/

Re: Eliminating too many record??

ecolomer — Thu, 07 Aug 2014 20:40:22 GMT

Try have all the records first and select only these you wont

Select only records selected and count it and compare

It is possible you have any problem with the relation inter files

Saludos,

Enrique Colomer

Re: Eliminating too many record??

Thu, 07 Aug 2014 20:57:04 GMT

Actually after some "poking" I found the answer

where [Servicing Sold Id] <>'NSM120110' seemed to work. still a little new at this