I have an excel that creates a new sheet every week with data.
So for the year 2013, I have every week a sheet with the name 2013-01, 2013-02 and so on.
So the first difficulty is how to generate multiple sheets in Qlikview without creating a new load script for every sheet.
The second problem is that I'm working with a crosstable with the date:
CrossTable(Date, Amount, 2)
(biff, embedded labels, header is 1 lines, table is [2013-26]
The problem here is that the dates also change every week.
How can I implement these excels for the entire year of 2013?
Have a look at the below links.
Check the below code
foreach file in FileList('R:\Harsha\qlikview\*.xlsx');