topic Re: Expression Question in App Development https://community.qlik.com/t5/App-Development/Expression-Question/m-p/1261706#M25704 <HTML><HEAD></HEAD><BODY><P>You should be able to do something like this:</P><P></P><P>Sum( {$&lt;[Version] = {'Actual'}, [Month] = {"<STRONG>$(=Capitalize(Date(Today(),'MMM')))</STRONG>"} AMOUNT)</P></BODY></HTML> Thu, 09 Mar 2017 23:26:40 GMT petter 2017-03-09T23:26:40Z Expression Question https://community.qlik.com/t5/App-Development/Expression-Question/m-p/1261705#M25703 <HTML><HEAD></HEAD><BODY><P>Hi - I'm relatively new to qlik sense and have a quick question which I hope provides a straight forward answer. I'm using this as an office solution and we have contract IT help that has built the back end for me. In my dashboard, I'm using the below expressions to calculate my actual expenditures in a period. How can I manipulate these expressions though to incorporate "current month" and "year to date" instead of having to manually adjust the months in the formula? See screenshot below.</P><P></P><P><IMG alt="2017-03-09_9-38-24.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155789_2017-03-09_9-38-24.jpg" style="height: auto;" /></P></BODY></HTML> Thu, 09 Mar 2017 15:24:01 GMT https://community.qlik.com/t5/App-Development/Expression-Question/m-p/1261705#M25703 2017-03-09T15:24:01Z Re: Expression Question https://community.qlik.com/t5/App-Development/Expression-Question/m-p/1261706#M25704 <HTML><HEAD></HEAD><BODY><P>You should be able to do something like this:</P><P></P><P>Sum( {$&lt;[Version] = {'Actual'}, [Month] = {"<STRONG>$(=Capitalize(Date(Today(),'MMM')))</STRONG>"} AMOUNT)</P></BODY></HTML> Thu, 09 Mar 2017 23:26:40 GMT https://community.qlik.com/t5/App-Development/Expression-Question/m-p/1261706#M25704 petter 2017-03-09T23:26:40Z