I built an application that has lot of Date columns.
We wrote lot of expressions on YTD, Prior YTD, Prior YE based on several dates.
My question now is,
Should I create calendar tables for EACH date and then use YTD, Prior YTD Flags ,Prior YE Flags on the calendar table
Should I continue to write SET Expressions ?
I'm tending not to go towards Calender route,As qlik has to first make a join and then do the calculations ,it might slightly be expensive than set expression.At the same time I'm not sure if Set Expressions on Date are expensive.