topic Re: MTD Charts in QlikView https://community.qlik.com/t5/QlikView/MTD-Charts/m-p/822752#M665315 <HTML><HEAD></HEAD><BODY><P>Sum({&lt; Date= {"&gt;=$(=Date(monthstart(max(Date)))&lt;=$(=Date(max(Date))"} &gt;} Value)</P></BODY></HTML> Tue, 20 Jan 2015 22:46:34 GMT jonasheisterkam 2015-01-20T22:46:34Z MTD Charts https://community.qlik.com/t5/QlikView/MTD-Charts/m-p/822751#M665314 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My requirement is to create MTD (Month to Date) charts based on the user selection of date. if the user select any date of the month Chart should display Actual and Plan information form start of the month to selected Date. For example if user selects 23/11/2014, then chart should display Actula and plan data form 1/11/2014 to 23/11/2014.</P><P></P><P>Can any one please advise me on the date expression in Chart. I have date in the format of DD/MM/YYYY.</P><P></P><P></P><P>Best Regards,</P></BODY></HTML> Tue, 20 Jan 2015 22:40:17 GMT https://community.qlik.com/t5/QlikView/MTD-Charts/m-p/822751#M665314 2015-01-20T22:40:17Z Re: MTD Charts https://community.qlik.com/t5/QlikView/MTD-Charts/m-p/822752#M665315 <HTML><HEAD></HEAD><BODY><P>Sum({&lt; Date= {"&gt;=$(=Date(monthstart(max(Date)))&lt;=$(=Date(max(Date))"} &gt;} Value)</P></BODY></HTML> Tue, 20 Jan 2015 22:46:34 GMT https://community.qlik.com/t5/QlikView/MTD-Charts/m-p/822752#M665315 jonasheisterkam 2015-01-20T22:46:34Z Re: MTD Charts https://community.qlik.com/t5/QlikView/MTD-Charts/m-p/822753#M665316 <HTML><HEAD></HEAD><BODY><P>Thanks Jonas,</P><P></P><P>The formula worked.</P><P></P><P></P><P>Regards.</P><P>Sandhya Molli</P></BODY></HTML> Thu, 22 Jan 2015 04:38:14 GMT https://community.qlik.com/t5/QlikView/MTD-Charts/m-p/822753#M665316 2015-01-22T04:38:14Z