topic Extract data from SAP- Where clause in QlikView

Extract data from SAP- Where clause

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How do you write 'Not Equal To' when extracting data from SAP? <> or != doesn't work. Thanks!

devarasu07 — Mon, 21 Aug 2017 23:49:21 GMT

Hi,

Try like this,

load * from table

Where

VRGAR='F'

and PALEDGER='01'

and Not match (WAAG,'01','02')

and Len(WAAG)>0;

Hope this helps to you

Thanks, Deva

Anil_Babu_Samineni — Tue, 22 Aug 2017 00:49:50 GMT

you can write this in qlik <>. If you making in SQL then define !=