Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Syed17
Contributor II
Contributor II

Convert Sql query to Qliksense script

Please help me to convert this query into qliksense script using qvds tables

Where pis7.ap_invoice_num not in (select invs7.invoice_num from ap_invoices_all invs7 where INVs7.SOURCE = 'Oracle Property Manager')

Labels (5)
2 Replies
SunilChauhan
Champion II
Champion II

Table1:
Load 

 invs7.invoice_num as invoice_num,

...

from ap_invoices_all invs7 where INVs7.SOURCE = 'Oracle Property Manager'

 

Load 

invoice_num,

...

from frist Table   where not EXISTS(invoice_num,invoice_num) ;

 

drop table table1;

hope this helps

Sunil Chauhan
Syed17
Contributor II
Contributor II
Author

I don't get proper solution by this step.