Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
nvrphanikumar
Contributor

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.