topic Re: Calculating MTD values dynamically in App Development https://community.qlik.com/t5/App-Development/Calculating-MTD-values-dynamically/m-p/984887#M14334 <HTML><HEAD></HEAD><BODY><P>How is the MTD field created? I suspect that only the days current month get a value 1 for that field. If that's the case then you can't use it for what you want to do. You can try creating and using an AsOf table like described in this document: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7; text-decoration: underline; background-color: #f8fbfe;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Thu, 29 Oct 2015 08:22:26 GMT Gysbert_Wassenaar 2015-10-29T08:22:26Z Calculating MTD values dynamically https://community.qlik.com/t5/App-Development/Calculating-MTD-values-dynamically/m-p/984886#M14333 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f4e79;">I am trying to build a MTD measure in QlikSense. The expression that I am using is –</SPAN></P><P></P><P><SPAN style="color: #1f4e79;">rangesum(above( sum({&lt;MTD={'1'}&gt;}[Attendee Amount]),0,rowno()))</SPAN></P><P></P><P><SPAN style="color: #1f4e79;">This does give the MTD numbers for the current month but in the sheet I have a drop down for months. If I choose any month other than the latest month I don’t get any values. Any ideas how I can make the expression dynamic?</SPAN></P></BODY></HTML> Wed, 28 Oct 2015 19:47:39 GMT https://community.qlik.com/t5/App-Development/Calculating-MTD-values-dynamically/m-p/984886#M14333 scw 2015-10-28T19:47:39Z Re: Calculating MTD values dynamically https://community.qlik.com/t5/App-Development/Calculating-MTD-values-dynamically/m-p/984887#M14334 <HTML><HEAD></HEAD><BODY><P>How is the MTD field created? I suspect that only the days current month get a value 1 for that field. If that's the case then you can't use it for what you want to do. You can try creating and using an AsOf table like described in this document: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7; text-decoration: underline; background-color: #f8fbfe;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Thu, 29 Oct 2015 08:22:26 GMT https://community.qlik.com/t5/App-Development/Calculating-MTD-values-dynamically/m-p/984887#M14334 Gysbert_Wassenaar 2015-10-29T08:22:26Z