Create a separate master date field in each of your table loads aliased the same name and Qlik associative data model will do the rest.
ID AS "Table1Id",
Table1Date AS "MasterDate",
.... Rest of your table 1 data
ID AS "Table2Id",
Table2Date AS "MasterDate",
.... Rest of your table 2 data
eu quero unificar as datas para filtro, mas nao usar em formulas de set analysis ex:
data tabela 1: 2016/10/10
data tabela 2: 2016/10/07
dia 7 e 10
as datas não tem nada a ver uma com a outra, mas eu gostaria de criar um calendario só quando eu puxar o ID 1 me trazer as datas.
deu para entender??
You have 2 choices.
1 you formally relate your dates and let Qlik handle the relationship this requires no set analysis. You will do this by either naming the date fields in each table the same or if you want to keep the date context in your model create a copy of the date field you want to use and name it a report date. (This was in my first post) you can then add the reporting date onto the page and filtering on a date will automatically filter all the records in your 5 tables on that date. Note you can extend the calendar filter by using the Year(), Month(), Day() functions if you want easier date filter groupings. If you want a range of days then look at creating buckets.
2 In my second post I talked about a way you can control the relationship of the dates in your charts and this was by using a bit of set analysis. Using set analysis allows you to control which of the 5 tables dates to use in a particular chart at a particular time you then wire it up to the Master calendar and the filtering will only then happen on the table data you want it to.
I think your answer is in these 2 approaches.