Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
HAAM
New Contributor II

Re: Generate month and year fields for a data set that don't contain date fields

Thank you all for the proper solution,

Like you said Marcus the best way is to solve it in beforehand.

But before  this card is being closed with the solution. 

Can you please explain me the approach to load the date from table name and which functions can be used for that?  

FROM [lib://AttachedFiles/mar+apr.xlsx]
(ooxml, embedded labels, table is DE_201903);

MVP & Luminary
MVP & Luminary

Re: Generate month and year fields for a data set that don't contain date fields

There is no native functionality in Qlik else it needs to be done per SQL or VBA/VBS. Here a few examples:

How-to-load-multiple-sheets-on-excel-file-into-Qlikview

Load-data-from-multiple-sheets-of-excel-file-dynamic-sheet-count

Another approach but not easier would be to unzip the XLSX (also per EXECUTE statement) and then reading the various xml-files to find the included sheets.

- Marcus