Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract data from SAP- Where clause

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

Capture2.PNG

2 Replies
devarasu07
Master II
Master II

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful