topic Re: Multiple YTD files in excel. in QlikView https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920015#M318849 <HTML><HEAD></HEAD><BODY><P>Awesome, thank you pal.</P></BODY></HTML> Wed, 29 Jul 2015 14:29:27 GMT 2015-07-29T14:29:27Z Multiple YTD files in excel. https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920011#M318845 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have multiple YTD files having data employee compensation in excel and which have to be loaded in Qlikview and difference between monthly YTD files is the monthly salary of each employee at employee ID level, which has to be calculated in script.</P><P></P><P>Please suggest way to calculate compensation in script.</P><P></P><P>I can do something like self join based on employee ID but in that case I believe I will have to change each field name manually for every file.</P><P></P><P>PFA the dummy data.</P><P></P><P>Regards,</P><P>Navdeep</P></BODY></HTML> Wed, 29 Jul 2015 12:00:52 GMT https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920011#M318845 2015-07-29T12:00:52Z Re: Multiple YTD files in excel. https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920012#M318846 <HTML><HEAD></HEAD><BODY><P>Can you post some examples?</P></BODY></HTML> Wed, 29 Jul 2015 12:22:32 GMT https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920012#M318846 Gysbert_Wassenaar 2015-07-29T12:22:32Z Re: Multiple YTD files in excel. https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920013#M318847 <HTML><HEAD></HEAD><BODY><P>Uploaded.</P></BODY></HTML> Wed, 29 Jul 2015 12:31:40 GMT https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920013#M318847 2015-07-29T12:31:40Z Re: Multiple YTD files in excel. https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920014#M318848 <HTML><HEAD></HEAD><BODY><P>Perhaps like in the attached example.</P></BODY></HTML> Wed, 29 Jul 2015 13:27:39 GMT https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920014#M318848 Gysbert_Wassenaar 2015-07-29T13:27:39Z Re: Multiple YTD files in excel. https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920015#M318849 <HTML><HEAD></HEAD><BODY><P>Awesome, thank you pal.</P></BODY></HTML> Wed, 29 Jul 2015 14:29:27 GMT https://community.qlik.com/t5/QlikView/Multiple-YTD-files-in-excel/m-p/920015#M318849 2015-07-29T14:29:27Z