topic Linking different TimeStamps to one Key in QlikView https://community.qlik.com/t5/QlikView/Linking-different-TimeStamps-to-one-Key/m-p/883131#M308020 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P></P><P>sorry for the strange topic, but i dont know how to describe it better in a few words.</P><P>I really am struggling since a few days with this problem and hope you are able to help me.</P><P></P><P>What i am trying to do is linking different timestamps in form of StartTime and EndTime to a MachineID.</P><P>I have one Table with ProductionData and StartTime and EndTime of Production as well as the MachineID.</P><P>I have another Table with LossData such as Machine Breakdowns also with StartTime and EndTime as well as the MachineID.</P><P></P><P>Breakdowns can occur everytime (also if no production is running).</P><P></P><P>The end Goal is to have lets say 24h in which i can calculated how much of the 24h was production or breakdown for a specific Machine.</P><P></P><P></P><P>I tried Intervalmatch without success, and also tried creating separate autogenerated calendars which break the timestamps down to minutes.</P><P></P><P>Do you have any idea what i could do? A new thinking approach would be great to hear.</P><P></P><P>All the best &amp; thank you in advance</P></BODY></HTML> Wed, 22 Apr 2015 12:29:35 GMT 2015-04-22T12:29:35Z Linking different TimeStamps to one Key https://community.qlik.com/t5/QlikView/Linking-different-TimeStamps-to-one-Key/m-p/883131#M308020 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P></P><P>sorry for the strange topic, but i dont know how to describe it better in a few words.</P><P>I really am struggling since a few days with this problem and hope you are able to help me.</P><P></P><P>What i am trying to do is linking different timestamps in form of StartTime and EndTime to a MachineID.</P><P>I have one Table with ProductionData and StartTime and EndTime of Production as well as the MachineID.</P><P>I have another Table with LossData such as Machine Breakdowns also with StartTime and EndTime as well as the MachineID.</P><P></P><P>Breakdowns can occur everytime (also if no production is running).</P><P></P><P>The end Goal is to have lets say 24h in which i can calculated how much of the 24h was production or breakdown for a specific Machine.</P><P></P><P></P><P>I tried Intervalmatch without success, and also tried creating separate autogenerated calendars which break the timestamps down to minutes.</P><P></P><P>Do you have any idea what i could do? A new thinking approach would be great to hear.</P><P></P><P>All the best &amp; thank you in advance</P></BODY></HTML> Wed, 22 Apr 2015 12:29:35 GMT https://community.qlik.com/t5/QlikView/Linking-different-TimeStamps-to-one-Key/m-p/883131#M308020 2015-04-22T12:29:35Z