topic Re: Load data filtering using fields from another table in QlikView

Load data filtering using fields from another table

MarcoARaymundo — Tue, 04 Jun 2013 20:19:59 GMT

Hi!

I have two tables: A and B. I want something like: Select * From A Where A.DTIN > B.DTCK.

We can do this in Qlikview?

jeffmartins — Wed, 05 Jun 2013 03:22:02 GMT

Hi thechacal,

First, you need to create a temporary table joining the tables A and B to get the fields DTIN and DTCK on the same table.

Then, you can create an other table to filter the values using the where clause DTIN > DTCK.

The code would be similar the following code:

tmp:

Load *;

Select * From A;

Left Join(tmp)

Load *;

Select * From B;

Table:

Noconcatenate

Load *

Resident tmp

Where DTIN > DTCK;

drop table tmp;

Hope it helps you

Regards:

MarcoARaymundo — Wed, 05 Jun 2013 11:37:34 GMT