topic Multiple Tables: Multiple Dates in QlikView https://community.qlik.com/t5/QlikView/Multiple-Tables-Multiple-Dates/m-p/1314303#M408191 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Can anyone tell me their experience when dealing with multiple dates, from multiple tables where each table isn't joined at a row level?</P><P></P><P>Each table represents a different tab that the user sees so the dates are not linked in any way but most of the other selectors/filters are. For now, I have a calendar in a floating table, not connected to the rest of the application and link to corresponding dates of each tab using set analysis (i.e. Sum({&lt;Year_Month_Table_Date_1 = P(YearMonth)&gt;} NumValue).</P><P></P><P>This works but it does mean that I can't use simple filters for users to select, they all have to be <SPAN style="font-size: 13.3333px;">Only({&lt;Year_Month_Table_Date_1 = P(YearMonth)&gt;} Selector).</SPAN></P><P></P><P>Each table is linked using each user's personal data (no unique row ID that ties everything together). Can anyone suggest a way to create a single master calendar that I can connect to my fact table?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 13 Apr 2017 11:48:19 GMT ciaran_mcgowan 2017-04-13T11:48:19Z Multiple Tables: Multiple Dates https://community.qlik.com/t5/QlikView/Multiple-Tables-Multiple-Dates/m-p/1314303#M408191 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Can anyone tell me their experience when dealing with multiple dates, from multiple tables where each table isn't joined at a row level?</P><P></P><P>Each table represents a different tab that the user sees so the dates are not linked in any way but most of the other selectors/filters are. For now, I have a calendar in a floating table, not connected to the rest of the application and link to corresponding dates of each tab using set analysis (i.e. Sum({&lt;Year_Month_Table_Date_1 = P(YearMonth)&gt;} NumValue).</P><P></P><P>This works but it does mean that I can't use simple filters for users to select, they all have to be <SPAN style="font-size: 13.3333px;">Only({&lt;Year_Month_Table_Date_1 = P(YearMonth)&gt;} Selector).</SPAN></P><P></P><P>Each table is linked using each user's personal data (no unique row ID that ties everything together). Can anyone suggest a way to create a single master calendar that I can connect to my fact table?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 13 Apr 2017 11:48:19 GMT https://community.qlik.com/t5/QlikView/Multiple-Tables-Multiple-Dates/m-p/1314303#M408191 ciaran_mcgowan 2017-04-13T11:48:19Z