Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikerB96
Contributor III
Contributor III

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 (2)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

View solution in original post

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
qlikerB96
Contributor III
Contributor III
Author

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?
dplr-rn
Partner - Master III
Partner - Master III

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
qlikerB96
Contributor III
Contributor III
Author

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.