topic CIA reports manager - capture input date from calendar object in QlikView https://community.qlik.com/t5/QlikView/CIA-reports-manager-capture-input-date-from-calendar-object/m-p/816248#M287884 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>My application uses CIA Reports Manager for Printing Qlikview Reports in Excel/Pdf .</P><P></P><P>I have <STRONG>2 calendar objects</STRONG> that use vPeriodStart and vPeriodEnd for defining start_date and end_date for defining date range. The charts in the app use the variables in the expression</P><P></P><P><STRONG>sum({TXDATE = {"&gt;=$(vPeriodStart)&lt;=$(vPeriodEnd)"}&gt;}AMT)</STRONG></P><P></P><P>(dates are in numeric format like 41929)</P><P></P><P>This works fine in Qlikview, and the data gets filtered n the basis of user selected dates.</P><P>Problem is , the generated report does not filter data on the date selected, but displays data for entire date range.</P><P></P><P>Request your help and thoughts on accomplishing this.</P></BODY></HTML> Tue, 25 Nov 2014 14:40:34 GMT sonikajain 2014-11-25T14:40:34Z CIA reports manager - capture input date from calendar object https://community.qlik.com/t5/QlikView/CIA-reports-manager-capture-input-date-from-calendar-object/m-p/816248#M287884 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>My application uses CIA Reports Manager for Printing Qlikview Reports in Excel/Pdf .</P><P></P><P>I have <STRONG>2 calendar objects</STRONG> that use vPeriodStart and vPeriodEnd for defining start_date and end_date for defining date range. The charts in the app use the variables in the expression</P><P></P><P><STRONG>sum({TXDATE = {"&gt;=$(vPeriodStart)&lt;=$(vPeriodEnd)"}&gt;}AMT)</STRONG></P><P></P><P>(dates are in numeric format like 41929)</P><P></P><P>This works fine in Qlikview, and the data gets filtered n the basis of user selected dates.</P><P>Problem is , the generated report does not filter data on the date selected, but displays data for entire date range.</P><P></P><P>Request your help and thoughts on accomplishing this.</P></BODY></HTML> Tue, 25 Nov 2014 14:40:34 GMT https://community.qlik.com/t5/QlikView/CIA-reports-manager-capture-input-date-from-calendar-object/m-p/816248#M287884 sonikajain 2014-11-25T14:40:34Z