Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
qliker96
New Contributor II

Qlik Sense where clause

Hi,

 

I would like to load for example two tables and I'd like to use some of the previously defined fields to filter the second table. How could I do this? I'd like to use both of the tables after the loading, so the first table is not a temptable. Because I get an error message which says, that 'The Filed does not exist'.

For example.:

Table1:

Load t1_ID,

t1_date;

FROM datasource;

And now I'd like to filter the Table to like that.: t2_ID = t1_ID and t2_date  <  t1_date. Neither Preload function nor SQL is working.

 

Labels (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: Qlik Sense where clause

after you load table 1 use either resident load (or repeat the load from your data source) with the where clause
if you are loading all the columns make sure you give no concatenate
4 Replies
Partner
Partner

Re: Qlik Sense where clause

after you load table 1 use either resident load (or repeat the load from your data source) with the where clause
if you are loading all the columns make sure you give no concatenate
qliker96
New Contributor II

Re: Qlik Sense where clause

If I'd like to use the the fields of Table one to filter Table to, like.:
t2_ID = t1_ID
and t2_date > t1_date.
Should I use the resident load also?
Partner
Partner

Re: Qlik Sense where clause

Not sure exactly what you mean.
but you can do that in front end using set analysis

Share an example data set and desired result
qliker96
New Contributor II

Re: Qlik Sense where clause

Thank you for the help ! It was useful I managed to find a solution, because of the dates I use the IntervalMatch().
I didn't realize that Qlik has more opportunities than native SQL.
Thank you.