topic Re: Macros in QlikView https://community.qlik.com/t5/QlikView/Macros/m-p/300103#M111147 <HTML><HEAD></HEAD><BODY><P><EM style="font-family: trebuchet ms,geneva;">Hi Gaayathri,</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">This is possible by using Set Analysis. I am not sure why you wanted to use the Macros. I would recommend you to avoid using Macros whenever possible, unless you have different requirement.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I am attaching an example for your reference. Here is the function I have used to get this working.</EM></P><P></P><P><SPAN style="color: #000080;"><STRONG><EM style="font-family: trebuchet ms,geneva;">SUM( {&lt;MyDate ={"&gt;=$(vStartDate) &lt;=$(vEndDate)"} &gt;} Sales)</EM></STRONG></SPAN></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Where vStartDate and vEndDate are variables which capture the Input Field Values.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I hope this helps! Let me know if you have any questions.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Cheers,</EM></P><P><EM style="font-family: trebuchet ms,geneva;">DV</EM></P></BODY></HTML> Thu, 29 Sep 2011 13:10:09 GMT IAMDV 2011-09-29T13:10:09Z Macros https://community.qlik.com/t5/QlikView/Macros/m-p/300102#M111146 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I want to know how to select range of dates in the listbox when selecting start date and end date in the inputbox using macros??</P><P></P><P>Please help me out!!</P></BODY></HTML> Thu, 29 Sep 2011 12:21:12 GMT https://community.qlik.com/t5/QlikView/Macros/m-p/300102#M111146 2011-09-29T12:21:12Z Re: Macros https://community.qlik.com/t5/QlikView/Macros/m-p/300103#M111147 <HTML><HEAD></HEAD><BODY><P><EM style="font-family: trebuchet ms,geneva;">Hi Gaayathri,</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">This is possible by using Set Analysis. I am not sure why you wanted to use the Macros. I would recommend you to avoid using Macros whenever possible, unless you have different requirement.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I am attaching an example for your reference. Here is the function I have used to get this working.</EM></P><P></P><P><SPAN style="color: #000080;"><STRONG><EM style="font-family: trebuchet ms,geneva;">SUM( {&lt;MyDate ={"&gt;=$(vStartDate) &lt;=$(vEndDate)"} &gt;} Sales)</EM></STRONG></SPAN></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Where vStartDate and vEndDate are variables which capture the Input Field Values.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I hope this helps! Let me know if you have any questions.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Cheers,</EM></P><P><EM style="font-family: trebuchet ms,geneva;">DV</EM></P></BODY></HTML> Thu, 29 Sep 2011 13:10:09 GMT https://community.qlik.com/t5/QlikView/Macros/m-p/300103#M111147 IAMDV 2011-09-29T13:10:09Z Re: Macros https://community.qlik.com/t5/QlikView/Macros/m-p/300104#M111148 <HTML><HEAD></HEAD><BODY><P>Hi DV,</P><P></P><P>Thanks a lot!!!! I got it</P><P></P><P>Regards,</P><P>Gaayathri</P></BODY></HTML> Fri, 30 Sep 2011 04:14:41 GMT https://community.qlik.com/t5/QlikView/Macros/m-p/300104#M111148 2011-09-30T04:14:41Z