I want those rows from the first table which has no matching rows exits in second table:
http://community.qlik.com/forums/t/17453.aspx.. kindly go through this llink. in that link attached a document refer that one.
hope it helps u
I am not getting what exactly you are trying to say. I want the do the following operation:
[SQL Statement 1]MINUS[SQL Statement 2]
Im also new in QV. Hope you get something from here.
table1:load * from sample1;table2:load * from sample2where not exists(id_field);
Or in join()
table1:load * from sample1;table2:outer join(table1)load * from sample2;
If i wrote something wrong please correct me.
i recommend it to see from Qlikview help.
or you can use
where not exists()
Retrieving data ...