topic Re: differnt sheet for different edit script in QlikView https://community.qlik.com/t5/QlikView/differnt-sheet-for-different-edit-script/m-p/363416#M1170610 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; By using interval match concept, you can link orddate between&nbsp; ordstdt and ordenddt.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp; You can refer about in reference manual or&nbsp; below posts:&nbsp; </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <A _jive_internal="true" href="https://community.qlik.com/message/192808#192808">http://community.qlik.com/message/192808#192808</A></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <A _jive_internal="true" href="https://community.qlik.com/message/222133#222133">http://community.qlik.com/message/222133#222133</A></P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 23 Jul 2012 19:55:37 GMT MayilVahanan 2012-07-23T19:55:37Z differnt sheet for different edit script https://community.qlik.com/t5/QlikView/differnt-sheet-for-different-edit-script/m-p/363415#M1170609 <HTML><HEAD></HEAD><BODY><P>i am new in qv</P><P></P><P>i have small queries</P><P></P><P>1)I have added 3 sheets . I want to write 3 different load script.</P><P>how can i write 3 different load script for 3 differnt sheet.</P><P></P><P>2)</P><P> i have a master table :</P><P></P><P>id&nbsp;&nbsp; ordstdt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ordenddt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rate</P><P></P><P>2&nbsp;&nbsp; 21/06/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/06/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</P><P>3&nbsp;&nbsp; 25/02/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03/03/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>4&nbsp;&nbsp; 03/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>2&nbsp;&nbsp; 01/07/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10/07/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P></P><P></P><P>in trans tab</P><P></P><TABLE><TBODY><TR><TD>id&nbsp;&nbsp; orddt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>qtysld</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><TABLE><TBODY><TR><TD>2&nbsp;&nbsp; 22/06/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>10</TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD>3&nbsp;&nbsp; 28/02/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>20</TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD>4&nbsp;&nbsp; 07/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>30</TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD>2&nbsp;&nbsp; 04/07/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>40</TD></TR></TBODY></TABLE><P></P><P></P><P>can i write in load script while orddate between&nbsp; ordstdt and ordenddt then it pick that particular rate and multiply qtysold in trans table.</P></BODY></HTML> Mon, 23 Jul 2012 17:58:07 GMT https://community.qlik.com/t5/QlikView/differnt-sheet-for-different-edit-script/m-p/363415#M1170609 Anonymous 2012-07-23T17:58:07Z Re: differnt sheet for different edit script https://community.qlik.com/t5/QlikView/differnt-sheet-for-different-edit-script/m-p/363416#M1170610 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; By using interval match concept, you can link orddate between&nbsp; ordstdt and ordenddt.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp; You can refer about in reference manual or&nbsp; below posts:&nbsp; </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <A _jive_internal="true" href="https://community.qlik.com/message/192808#192808">http://community.qlik.com/message/192808#192808</A></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <A _jive_internal="true" href="https://community.qlik.com/message/222133#222133">http://community.qlik.com/message/222133#222133</A></P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 23 Jul 2012 19:55:37 GMT https://community.qlik.com/t5/QlikView/differnt-sheet-for-different-edit-script/m-p/363416#M1170610 MayilVahanan 2012-07-23T19:55:37Z