Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Two data sets with different amounts of records

Hello,  I have pulled two sets of data into Qlikview and joined them by a unique reference number.  The second set of data is larger meaning I have data missing from the first set of data.

Is it possible to limit the data being display to the number of records contained in the first set of data??  Eg make it appear the extra data from the seconds set is not there at all?

Thanks You (Day two on Qlikview)

1 Solution

Accepted Solutions
rubenmarin

If there is a unique reference number by row you can use left join

Table1:

LOAD ... From table1;

Left Join LOAD ... From Table2;

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Load

     Field1,

     CommonField,

     Field2....

From Table1;

Load

     Field3,

     CommonField,

     Field4....

From Table2

Where Exists(CommonField);

rubenmarin

If there is a unique reference number by row you can use left join

Table1:

LOAD ... From table1;

Left Join LOAD ... From Table2;

anbu1984
Master III
Master III

TAB1:

load * inline [

country, sales

Brazil, 234

US, 432

Germany, 121

India, 444];

Join(TAB1)

load * inline [

country, Profit

US, 412

Germany, 488

India, 224

China,101];

NoConcatenate

Final:

Load * Resident TAB1 where Not(IsNull(sales));

Drop Table TAB1;

bazzaonline
Creator
Creator
Author

Brilliant, worked perfectly!

MK_QSL
MVP
MVP

Kindly close the thread by selection appropriate answer...