topic How to add selection into load statement in QlikView

How to add selection into load statement

Wed, 03 Nov 2010 15:15:09 GMT

I need help, how to put the following logic into load statement. Shouldn't be rocket science, but I just can't get it right! 🙂

I am first loading table 1 (header) with load statement :

TABLE1:

Load

FROM A1.qvd;

I know that there is only 1 ID in the source, which keeps changing every minute. Next I need to load only that ID into table 2.

TABLE2:

Load

ID,

Date,

TIME

FROM

B1.qvd;

How can I select to load only the data with ID from table 1, into table 2?

How to add selection into load statement

Wed, 03 Nov 2010 15:24:50 GMT

If I understand your problem correctly, you need to do a resident:

TABLE2:

load x,

resident TABLE1;

How to add selection into load statement

Wed, 03 Nov 2010 15:35:07 GMT

Yes, but how to do the syntax in my case? I have fields ID, Date & TIME in my data...

How to add selection into load statement

Wed, 03 Nov 2010 15:40:28 GMT

Use JOIN between table...

TABLE1:

Load

FROM A1.qvd;

TABLE2:

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

B1.qvd;

How to add selection into load statement

Thu, 04 Nov 2010 12:17:57 GMT

Thank you! This was, what I was looking for!

How to add selection into load statement

Sat, 29 Jan 2011 11:37:03 GMT

For some reason I am not able to load more than one table using inner join. I would like to read in the 1st table as a validator for the rest of the tables B1, C1 etc. So basically:

TABLE1:

Load

FROM A1.qvd;

TABLE2:

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

B1.qvd;

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

C1.qvd;

INNER JOIN(TABLE1) Load

ID,

Date,

TIME

FROM

D1.qvd;

How to add selection into load statement

Thu, 31 Mar 2011 12:27:55 GMT

For some reason I am stuck with a similar problem again. I have 2 identical files (Danish_customers, Other_Customers). I would need a report to compare which Customers exist both in Danish_customers and Other_Customers. Something like this:

Danish_customers:

LOAD

CUSTOMERID,

CUSTOMERNAME

FROM Danish_customers.xlsx;

Other_Customers:

INNER JOIN(Danish_customers)

LOAD

CUSTOMERID,

CUSTOMERNAME

FROM Other_Customers.xlsx;

For some reason I end up with a report including ALL customers (All Other+Denmark) instead of getting a list of just the customers that exist both in Denmark and other places. What is it I am doing wrong here?

Example of the data:

Danish_customers:

CUSTOMERID CUSTOMERNAME

1234 Johnny Appleseed

2345 Jorgos Aviorikos

....

Other_customers:

CUSTOMERID CUSTOMERNAME

B3203 John Smith

2345 Jorgos Aviorikos <-- same as in Danish_customers

....

In this case I would like to collect only the customer 2345 in my final report.

How to add selection into load statement

bismart — Thu, 31 Mar 2011 13:13:11 GMT

Try this simpler approach using 1 table...

Customers:

LOAD
CUSTOMERID,
CUSTOMERNAME,
'DANISH' as [Customer Type]
FROM Danish_customers.xlsx;

LOAD
CUSTOMERID,
CUSTOMERNAME,
'OTHER' as [Customer Type]
FROM Other_customers.xlsx;

Create report

Dimension: CUSTOMERID
expression: count([Customer Type])

Sort by expression descending...