Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can any one suggest how to make FromDate and ToDate Calendar From Backend..
i have one scenario in which user need to select from_Date and To_Date and Data should be shown In-between them.
Exactly like the calendar object available in qlikview.
i don't want to do it from front end..
Please Advice..
Regards
Abhay
You can do this by using two AsOf-tables in your data model; one pointing forwards in time, one pointing backwards.
See the following links for more on AsOf tables:
Calculating rolling n-period totals, averages or other aggregations
QlikView Blog Q-Tip #4 How to Use "As of Date" table | Natural Synergies
HIC
Hi Henric,
Do you have any Sample file for same?
Thanks
Abhay
You can use the following snippet as a template for a solution:
Calendar:
Load
Year(Date) as Year,
Month(Date) as month,
Date(MonthStart(Date),'YYYY-MM') as Month,
*;
Load Date(MakeDate(2015) -1 + RecNo()) as Date
Autogenerate 365 ;
StartDate:
Load * Where Date >= StartDate;
Load Date,
Date(MakeDate(2015) -1 + IterNo()) as StartDate
Resident Calendar While IterNo() <= 365 ;
EndDate:
Load * Where Date <= EndDate;
Load Date,
Date(MakeDate(2015) -1 + IterNo()) as EndDate
Resident Calendar While IterNo() <= 365 ;
HIC