topic Dates suggestion in QlikView https://community.qlik.com/t5/QlikView/Dates-suggestion/m-p/1327087#M410425 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I built an application that has lot of Date columns.</P><P>We wrote lot of expressions on YTD, Prior YTD, Prior YE based on several dates.</P><P></P><P>My question now is,</P><P>Should I create calendar tables for EACH date and then use YTD, Prior YTD Flags ,Prior YE Flags on the calendar table</P><P>or</P><P>Should I continue to write SET Expressions ?</P><P></P><P>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.</P><P></P><P>Please suggest.</P></BODY></HTML> Thu, 11 May 2017 13:46:35 GMT nvrphanikumar 2017-05-11T13:46:35Z Dates suggestion https://community.qlik.com/t5/QlikView/Dates-suggestion/m-p/1327087#M410425 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I built an application that has lot of Date columns.</P><P>We wrote lot of expressions on YTD, Prior YTD, Prior YE based on several dates.</P><P></P><P>My question now is,</P><P>Should I create calendar tables for EACH date and then use YTD, Prior YTD Flags ,Prior YE Flags on the calendar table</P><P>or</P><P>Should I continue to write SET Expressions ?</P><P></P><P>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.</P><P></P><P>Please suggest.</P></BODY></HTML> Thu, 11 May 2017 13:46:35 GMT https://community.qlik.com/t5/QlikView/Dates-suggestion/m-p/1327087#M410425 nvrphanikumar 2017-05-11T13:46:35Z