Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nvrphanikumar
New Contributor III

Dates suggestion

Hi,

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

or

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.

Please suggest.