Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Luminary

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
Luminary

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

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
MVP & Luminary
MVP & Luminary

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