topic Re: Join or Keep ON date columns in QlikView

Join or Keep ON date columns

Fri, 04 Nov 2016 15:33:32 GMT

Is it possible to do a Left Join or a Left Keep ON a table1.datecolumn > table2.datecolumn?

I have users who joined a pilot program, and I only need to load sales that they've made after the pilot program started. I have the user's ID for the join/keep and would also like to join based on the sale_date >= pilot_start_date (different for each user).

I can create an indicator, but then the user would need to filter based on that indicator column every time, which I don't want to have.

Re: Join or Keep ON date columns

maxgro — Fri, 04 Nov 2016 17:55:32 GMT

if you don't have a lot of rows you can join the tables with userid and add the 2 fields

table1.datecolumn, table2.datecolumn

then with a resident load filter the rows where table1.datecolumn > table2.datecolumn

Re: Join or Keep ON date columns

Mon, 07 Nov 2016 21:16:10 GMT

Great, that works. Thanks!