topic Getting not maching row of a table in QlikView

Getting not maching row of a table

Mon, 11 Apr 2011 12:57:57 GMT

Hi,

I want those rows from the first table which has no matching rows exits in second table:

Thanks

Mon, 11 Apr 2011 13:03:12 GMT

Use joins

Mon, 11 Apr 2011 13:05:31 GMT

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

Mon, 11 Apr 2011 13:06:32 GMT

http://community.qlik.com/forums/t/17453.aspx

Mon, 11 Apr 2011 13:06:56 GMT

or you can use

where not exists()

Mon, 11 Apr 2011 13:31:30 GMT

Hi,

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]

Mon, 11 Apr 2011 13:32:16 GMT

Hi,

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]

Mon, 11 Apr 2011 13:44:33 GMT

Im also new in QV. Hope you get something from here.


table1:
load * from sample1;
table2:
load * from sample2
where 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.

Mon, 11 Apr 2011 13:49:04 GMT

i recommend it to see from Qlikview help.