Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a series of csv files that I have loaded into a qvd file. See the thread here: http://community.qlik.com/thread/113287
I am trying to load the year, month, and day from the "Date" field. I have a separate .qvw file where this works fine, and there are several posts here that show how to do this. Since my file has a loop to add new .csv files to the .qvd, I don't know where to put the LOAD statement to make this work. I have made several attempts by trial and error, but I can't figure out how to make this work.
I have a different file where this works fine, but all of the data is loaded from a single .xlsx file.
So I have no idea where this LOAD statement should go:
Directory;
LOAD Date,
Month(Date) as MonthDate,
Time(Date) as TimeDate,
Year(Date) as YearDate,
Day(Date) as DayDate;
The above code causes an error with the Autogenerate line in the attached file.
Thanks,
-Kristan
Use the master calendar for the application and create a master calendar from the date field and then connect them some thing like example.
Let varMinDate = Num(Makedate(2006,1,1));
Let varMaxDate = Num(Makedate(Year(today()),Month(today()),Day(today())));
Datefield:
LOAD
Date($(varMinDate)+IterNo()-1) AS Datefield,
Year(date($(varMinDate)+IterNo()-1)) as Year,
Month(date($(varMinDate)+IterNo()-1)) as Month,
Day(date($(varMinDate)+IterNo()-1)) as Day,
Time(date($(varMinDate)+IterNo()-1)) as Time
AUTOGENERATE (1)
WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);