topic Interval Match in QlikView https://community.qlik.com/t5/QlikView/Interval-Match/m-p/982425#M957201 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I am attching a qvw and a qvd with this. I want to create a composite key from date , kschl, vsart .</P><P>For that i have to join the table but whenever i am joining the table it goes on a toss.</P><P>I think i am missing something.</P><P>Please help </P></BODY></HTML> Thu, 12 Nov 2015 10:08:02 GMT 2015-11-12T10:08:02Z Interval Match https://community.qlik.com/t5/QlikView/Interval-Match/m-p/982425#M957201 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I am attching a qvw and a qvd with this. I want to create a composite key from date , kschl, vsart .</P><P>For that i have to join the table but whenever i am joining the table it goes on a toss.</P><P>I think i am missing something.</P><P>Please help </P></BODY></HTML> Thu, 12 Nov 2015 10:08:02 GMT https://community.qlik.com/t5/QlikView/Interval-Match/m-p/982425#M957201 2015-11-12T10:08:02Z Re: Interval Match https://community.qlik.com/t5/QlikView/Interval-Match/m-p/982426#M957202 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> I want to create a composite key from date , kschl, vsart</SPAN></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>First of all: Why? Your document contains only two tables. What do you need that new key field for?</P><P></P><P>Secondly, if you want to create a key from fields from several tables then you have to join those tables first so you have one table that contains all the fields you want to make the key from.</P></BODY></HTML> Fri, 13 Nov 2015 12:17:28 GMT https://community.qlik.com/t5/QlikView/Interval-Match/m-p/982426#M957202 Gysbert_Wassenaar 2015-11-13T12:17:28Z