Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Not applicable

Getting not maching row of a table

Hi,

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

Thanks

8 Replies
Highlighted
Not applicable

Getting not maching row of a table

Use joins

Highlighted
Not applicable

Getting not maching row of a 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

Highlighted
Not applicable

Getting not maching row of a table

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

Highlighted
Not applicable

Getting not maching row of a table

or you can use

where not exists()

Highlighted
Not applicable

Getting not maching row of a table

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]

Highlighted
Not applicable

Getting not maching row of a table

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]

Highlighted
Not applicable

Getting not maching row of a table

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.

Highlighted
Not applicable

Getting not maching row of a table

i recommend it to see from Qlikview help.