which date column you need to be in ranges of week, month and quarter??
With this part of script
date(BegDateOfOperation) as BegDateOfOperation,
date(EndDateOfOperation) as EndDateOfOperation
[C:\Users\agrando\Desktop\Alex's Stuff\Sample Data.xlsx]
(ooxml, embedded labels, table is Sheet2);
LEFT JOIN (Data)
LOAD year(Today())-IterNo()+1 as YearGranularity
While IterNo() <=4;
as you are not having YearGranularity field in Data table, its a cross join. You may need interval match with calendar and BegDateOfOperation,EndDateOfOperation.
Thank you for your response. I'm still very new to QlikView and not sure what you mean. I'm trying to trend the count of active %PropertyKey on any given granularity specified by the user. The BegDateOfOperation and EndDateOfOperation columns are used to calculate whether the property was active during the time frame that the user specifies. Please let me know if you have any more questions or comments.