topic Connecting Qlikview to multiple sheets in same Excel in QlikView https://community.qlik.com/t5/QlikView/Connecting-Qlikview-to-multiple-sheets-in-same-Excel/m-p/306875#M706717 <HTML><HEAD></HEAD><BODY><P>I'm a new user of Qlikview and found in the tutorials the way to integrate different files, but how do I link this when the data are all in the same file, but in different sheets as for instance with an Excel-file ? The data in the different&nbsp; sheets so could be concatenated. </P><P></P><P>An example would be sales figures of different years are in corresponding sheets in the same file.</P><P></P><P>Thanks in advance for the responses !</P><P></P><P>Stijn</P></BODY></HTML> Wed, 25 Jan 2012 18:15:14 GMT 2012-01-25T18:15:14Z Connecting Qlikview to multiple sheets in same Excel https://community.qlik.com/t5/QlikView/Connecting-Qlikview-to-multiple-sheets-in-same-Excel/m-p/306875#M706717 <HTML><HEAD></HEAD><BODY><P>I'm a new user of Qlikview and found in the tutorials the way to integrate different files, but how do I link this when the data are all in the same file, but in different sheets as for instance with an Excel-file ? The data in the different&nbsp; sheets so could be concatenated. </P><P></P><P>An example would be sales figures of different years are in corresponding sheets in the same file.</P><P></P><P>Thanks in advance for the responses !</P><P></P><P>Stijn</P></BODY></HTML> Wed, 25 Jan 2012 18:15:14 GMT https://community.qlik.com/t5/QlikView/Connecting-Qlikview-to-multiple-sheets-in-same-Excel/m-p/306875#M706717 2012-01-25T18:15:14Z Re: Connecting Qlikview to multiple sheets in same Excel https://community.qlik.com/t5/QlikView/Connecting-Qlikview-to-multiple-sheets-in-same-Excel/m-p/306876#M706719 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><EM>Hi,</EM></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><EM>for that you can use a for loop.which will loop through all the needed sheets.</EM></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><EM>Please find the attached sample application and excel file.</EM></SPAN></P><P></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><EM>....</EM></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><EM>Ashutosh</EM></SPAN></P></BODY></HTML> Wed, 25 Jan 2012 18:35:56 GMT https://community.qlik.com/t5/QlikView/Connecting-Qlikview-to-multiple-sheets-in-same-Excel/m-p/306876#M706719 2012-01-25T18:35:56Z