topic Working with multiple records with the same key field in QlikView https://community.qlik.com/t5/QlikView/Working-with-multiple-records-with-the-same-key-field/m-p/448750#M1152554 <HTML><HEAD></HEAD><BODY><P>Hey, complete newb question here.</P><P></P><P>Just to be sure, I'm assuming key field is the same as primary key in databases?</P><P></P><P>Anyway.</P><P></P><P>I've loaded the database in, and now I want to use two bits of data from two records with the same primary key.</P><P></P><P>So, say I'm creating a simple straight table and I want to calculate the difference in dates between when the primary key appeared.</P><P></P><P>I know I need to use interval, but I don't know how to get the information for the two dates.</P><P></P><P>Interval([PrimaryKeyFieldName].date - [PrimaryKeyFieldName].date, 'dd')?</P><P></P><P>I literally don't have an idea at this point.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 12 Apr 2013 10:26:50 GMT 2013-04-12T10:26:50Z Working with multiple records with the same key field https://community.qlik.com/t5/QlikView/Working-with-multiple-records-with-the-same-key-field/m-p/448750#M1152554 <HTML><HEAD></HEAD><BODY><P>Hey, complete newb question here.</P><P></P><P>Just to be sure, I'm assuming key field is the same as primary key in databases?</P><P></P><P>Anyway.</P><P></P><P>I've loaded the database in, and now I want to use two bits of data from two records with the same primary key.</P><P></P><P>So, say I'm creating a simple straight table and I want to calculate the difference in dates between when the primary key appeared.</P><P></P><P>I know I need to use interval, but I don't know how to get the information for the two dates.</P><P></P><P>Interval([PrimaryKeyFieldName].date - [PrimaryKeyFieldName].date, 'dd')?</P><P></P><P>I literally don't have an idea at this point.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 12 Apr 2013 10:26:50 GMT https://community.qlik.com/t5/QlikView/Working-with-multiple-records-with-the-same-key-field/m-p/448750#M1152554 2013-04-12T10:26:50Z