Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have an issue in Qlikview and don't know how to proceed.
I have 2 tables in a database : Table1 (train routing) & Table2 (season)
In table1 we have rows like :
In table2 we have rows like :
In my Qlikview doc, I have load the two tables like :
A:
LOAD Dep_station, Arr_station, dep_time, arr_time, Date(Floor(Date(dep_time,'DD/MM/YYYY'))) as DateUnique ;
SQL SELECT *
FROM "Table1"
WHERE dep_time>= '01/01/2012';
B:
LOAD DISTINCT Season_DESCRIPTION, floor(date_BEGIN) as S_BEGIN, floor(date_END) as S_END
;
SQL SELECT * FROM Table2 WHERE date_BEGIN>= '01/01/2011';
In the graphic view I just want a table with all information of table A and a filter so that when I choose a season in B (ex: Winter 2014), it filters all rows in A where depature_time is between the date_begin and date_end of the season...
And I don't know how to interrelate these 2 tables ? In the script ? In the graphic view ?
Thank you in advance for your help.
My bests,
Quy Thanh
Hi Quy,
I upload an example using intervalmatch, hope this helps.
Thank you so much
I've finaly did it; I had some issues with qualify / unqualify to recognize the right fields but It's OK now.
Thanks again !