topic Re: Month to date sum based on selected date in QlikView https://community.qlik.com/t5/QlikView/Month-to-date-sum-based-on-selected-date/m-p/285607#M498293 <HTML><HEAD></HEAD><BODY><DIV>This is an example&nbsp; using variables, make sure you make first Variables with this names then try it!!</DIV><DIV> </DIV><DIV><DIV><SPAN style="font-size: 8pt;"><DIV><SPAN style="font-size: 10pt;">=</SPAN></DIV></SPAN></DIV><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">SUM</SPAN>({&lt;<SPAN style="color: #800000;">Year</SPAN>={'$(vMaxYear)'},<SPAN style="color: #800000;">Month</SPAN>={'$(vMaxMonth)'},<SPAN style="color: #800000;">Day</SPAN>={'&lt;=$(vMaxDay)-1'},<SPAN style="color: #800000;">Date</SPAN>=,<SPAN style="color: #800000;">MonthYear</SPAN>=&gt;}<SPAN style="color: #800000;">Amount</SPAN>) </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV></BODY></HTML> Fri, 19 Aug 2011 13:59:29 GMT 2011-08-19T13:59:29Z Month to date sum based on selected date https://community.qlik.com/t5/QlikView/Month-to-date-sum-based-on-selected-date/m-p/285606#M498292 <HTML><HEAD></HEAD><BODY><P>Hi I am wanting to sum the total revenue we taken within a month, based on any selected date.</P><P>I currently have use set analysis to sum mtd up until yesterday:</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>sum({&lt;[BudgetL1L2 Date]={"&gt;=$(=Monthstart(date(today()-1)))"}&gt;} [Revenue Net]) </P><P></P><P>However i am stumped as to how i cam amned this to base it on any selected date.</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN>Does anyone have any ideas?</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN>Many thanks</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN>Kate</P></BODY></HTML> Fri, 19 Aug 2011 11:35:00 GMT https://community.qlik.com/t5/QlikView/Month-to-date-sum-based-on-selected-date/m-p/285606#M498292 2011-08-19T11:35:00Z Re: Month to date sum based on selected date https://community.qlik.com/t5/QlikView/Month-to-date-sum-based-on-selected-date/m-p/285607#M498293 <HTML><HEAD></HEAD><BODY><DIV>This is an example&nbsp; using variables, make sure you make first Variables with this names then try it!!</DIV><DIV> </DIV><DIV><DIV><SPAN style="font-size: 8pt;"><DIV><SPAN style="font-size: 10pt;">=</SPAN></DIV></SPAN></DIV><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">SUM</SPAN>({&lt;<SPAN style="color: #800000;">Year</SPAN>={'$(vMaxYear)'},<SPAN style="color: #800000;">Month</SPAN>={'$(vMaxMonth)'},<SPAN style="color: #800000;">Day</SPAN>={'&lt;=$(vMaxDay)-1'},<SPAN style="color: #800000;">Date</SPAN>=,<SPAN style="color: #800000;">MonthYear</SPAN>=&gt;}<SPAN style="color: #800000;">Amount</SPAN>) </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV></BODY></HTML> Fri, 19 Aug 2011 13:59:29 GMT https://community.qlik.com/t5/QlikView/Month-to-date-sum-based-on-selected-date/m-p/285607#M498293 2011-08-19T13:59:29Z