Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date in tab, need to set months from tabs

I have a spreadsheet with the tab names as the date of the monthly data. How do I set the month for each table in the script when I load the files? So May 2010, June 2010, July 2010 tabs are loaded individually and in the load statement, when I input "Set date" or "set month" or Set May" I get an error statement. I hope that makes sense.

1 Solution

Accepted Solutions
pover
Luminary Alumni
Luminary Alumni

If I understand correctly for each Excel, do the following:

Load makedate(2010,5,1) as Date,
... // Other columns
From x.xls (... May$);

Regards.

View solution in original post

3 Replies
pover
Luminary Alumni
Luminary Alumni

If I understand correctly for each Excel, do the following:

Load makedate(2010,5,1) as Date,
... // Other columns
From x.xls (... May$);

Regards.

Not applicable
Author

Thanks, that takes care of the date, but now how do I set the year so that when I begin to add data next year I can compare the monthly results?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

For a very flexible approach, take a look at this blog post:
http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html

and The QV Cookbbok example, "Load multiple sheets from Excel workbook". The first part of the example, "Mutli Sheet load" is just like your example except you don't need to filter out sheets. The SheetName variable in the script can be parsed to get the month and year for your MakeDate.

-Rob