Connecting Qlikview to multiple sheets in same Excel

[#1]

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  sheets so could be concatenated.

An example would be sales figures of different years are in corresponding sheets in the same file.

Thanks in advance for the responses !

Stijn

[#2]

Hi,

for that you can use a for loop.which will loop through all the needed sheets.

Please find the attached sample application and excel file.

....

Ashutosh