Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
chris_mccann
Contributor
Contributor

How do I exclude, using a WHERE clause, all fields that contain 'INTF' in the Purchase Invoice Description, somewhere?

This is what i am doing at the min:

LOAD ProteanTPObjectID,
          PurchaseInvNo,
          CalendarLink,
          ProteanInvCreateDate,
          ProteanInvValue,
          ProteanInvStatus,
          ProteanInvSite,
          ProteanInvType,
          DocuWareInvTotalAmount,
          DocuWareInvStatus,
          ProteanTPDesc,
          ProteanInvDesc
    
FROM $(datasource)PI_DocUWare_Invoice.qvd (qvd);

WHERE ( ProteanInvSite <> 'S05'
AND  ProteanInvSite <> 'S06'
AND  ProteanInvSite <> 'S35')
AND   (LEFT(PurchaseInvNo,3) <> 'POI');

Labels (1)
0 Replies