Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Connecting Qlikview to multiple sheets in same Excel

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

1 Reply
Not applicable

Re: Connecting Qlikview to multiple sheets in same Excel

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