topic Qliksense: Calendar Problem: Need to connect three Data sources with Calendar in QlikView https://community.qlik.com/t5/QlikView/Qliksense-Calendar-Problem-Need-to-connect-three-Data-sources/m-p/1160627#M634463 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have three type of data:-</P><P></P><P>1) Actual Data with Start and End Date(TImestamp)</P><P>2) Planned Data with Start Date <SPAN style="font-size: 13.3333px;">(Timestamp)</SPAN></P><P>3) Forecast Data with Start Date(Timestamp)</P><P></P><P>I loaded 6 years to till date Calendar and renamed the Start Date in every type of data so that there is association between all the tables but synthetic key is coming.</P><P></P><P>Also when I am applying LEFT KEEP , it is only showing today;s date. </P><P></P><P>Please help me out with this. <A href="https://community.qlik.com/qlik-users/202070">reddys310</A>‌ <A href="https://community.qlik.com/space/2061">Scripting</A>‌ </P><P></P><P></P><P>I am attaching QVF file as well as data.</P><P></P><P>Regards</P><P>Rohit Parimal</P></BODY></HTML> Fri, 27 May 2016 12:17:18 GMT 2016-05-27T12:17:18Z Qliksense: Calendar Problem: Need to connect three Data sources with Calendar https://community.qlik.com/t5/QlikView/Qliksense-Calendar-Problem-Need-to-connect-three-Data-sources/m-p/1160627#M634463 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have three type of data:-</P><P></P><P>1) Actual Data with Start and End Date(TImestamp)</P><P>2) Planned Data with Start Date <SPAN style="font-size: 13.3333px;">(Timestamp)</SPAN></P><P>3) Forecast Data with Start Date(Timestamp)</P><P></P><P>I loaded 6 years to till date Calendar and renamed the Start Date in every type of data so that there is association between all the tables but synthetic key is coming.</P><P></P><P>Also when I am applying LEFT KEEP , it is only showing today;s date. </P><P></P><P>Please help me out with this. <A href="https://community.qlik.com/qlik-users/202070">reddys310</A>‌ <A href="https://community.qlik.com/space/2061">Scripting</A>‌ </P><P></P><P></P><P>I am attaching QVF file as well as data.</P><P></P><P>Regards</P><P>Rohit Parimal</P></BODY></HTML> Fri, 27 May 2016 12:17:18 GMT https://community.qlik.com/t5/QlikView/Qliksense-Calendar-Problem-Need-to-connect-three-Data-sources/m-p/1160627#M634463 2016-05-27T12:17:18Z