topic Re: Sharing a timestamp dimension from two data sources? in QlikView https://community.qlik.com/t5/QlikView/Sharing-a-timestamp-dimension-from-two-data-sources/m-p/936919#M953788 <HTML><HEAD></HEAD><BODY><P>How does you load script and the resulting tables look like?</P><P></P><P>See also</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A>‌</P><P><A href="https://community.qlik.com/message/283501">Tutorial - Using Common Date Dimensions and Shared Calendars</A></P><P></P><P>Which should get you an idea of how you can achieve what you want (these document are for dates, but you can possibly apply similar to your timestamps). </P></BODY></HTML> Thu, 19 Nov 2015 15:19:12 GMT swuehl 2015-11-19T15:19:12Z Sharing a timestamp dimension from two data sources? https://community.qlik.com/t5/QlikView/Sharing-a-timestamp-dimension-from-two-data-sources/m-p/936918#M953787 <HTML><HEAD></HEAD><BODY><P>Hi, I have three data excel files with timestamps of the same format. The three sources have similar data, and I'd like to plot data from all three sources on my y-axis, while sharing the same x-axis of timestamps.</P><P></P><P>I am currently using the * functionality in the FROM part of my script to load multiple data sources, and I can plot and show the data from the respective files successfully. However, I am unable to show visualize data from different sources on the same graph. Would this be possible? I have tried truncating the timestamps to the hour and minute instead of seconds, so that there would be more common timestamps across the excel sheets, but to no avail.</P><P></P><P>Another thing I have tried is setting the x-axis of a graph to the timestamps of Source A, while setting the y-axis to a column of Source B. I am positive that Source B shares some of the timestamps of Source A, but I get the "No data to display" error. Would this be possible to implement? </P><P></P><P>It would be easiest if I just merged all the data into one file, but I have millions of rows and cannot fit everything into one file. Thank you.</P></BODY></HTML> Thu, 19 Nov 2015 01:21:04 GMT https://community.qlik.com/t5/QlikView/Sharing-a-timestamp-dimension-from-two-data-sources/m-p/936918#M953787 2015-11-19T01:21:04Z Re: Sharing a timestamp dimension from two data sources? https://community.qlik.com/t5/QlikView/Sharing-a-timestamp-dimension-from-two-data-sources/m-p/936919#M953788 <HTML><HEAD></HEAD><BODY><P>How does you load script and the resulting tables look like?</P><P></P><P>See also</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A>‌</P><P><A href="https://community.qlik.com/message/283501">Tutorial - Using Common Date Dimensions and Shared Calendars</A></P><P></P><P>Which should get you an idea of how you can achieve what you want (these document are for dates, but you can possibly apply similar to your timestamps). </P></BODY></HTML> Thu, 19 Nov 2015 15:19:12 GMT https://community.qlik.com/t5/QlikView/Sharing-a-timestamp-dimension-from-two-data-sources/m-p/936919#M953788 swuehl 2015-11-19T15:19:12Z