topic Re: FromDate and ToDate Calendar From Backend in QlikView

FromDate and ToDate Calendar From Backend

abhaysingh — Wed, 07 Oct 2015 07:57:54 GMT

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

Re: FromDate and ToDate Calendar From Backend

hic — Wed, 07 Oct 2015 09:08:09 GMT

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

Re: FromDate and ToDate Calendar From Backend

abhaysingh — Wed, 07 Oct 2015 12:33:30 GMT

Hi Henric,

Do you have any Sample file for same?

Thanks

Abhay

Re: FromDate and ToDate Calendar From Backend

hic — Wed, 07 Oct 2015 13:32:22 GMT

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