topic Re: Calculating current month sales in QlikView https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363464#M459780 <HTML><HEAD></HEAD><BODY><P>Do you have a MonthNum field in your application?</P></BODY></HTML> Mon, 07 Aug 2017 14:41:23 GMT sunny_talwar 2017-08-07T14:41:23Z Calculating current month sales https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363463#M459779 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have created a variable to calculate the current financial month;</P><P><EM>vFINMNT</EM> =</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">month</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AddMonths</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">(),-3))) </SPAN></P><P></P><P>I now need to create an expression that calculates the current months sales without selecting the financial month but having difficulty creating it, can anyone help?</P><P></P><P>TIA</P></BODY></HTML> Mon, 07 Aug 2017 14:38:47 GMT https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363463#M459779 2017-08-07T14:38:47Z Re: Calculating current month sales https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363464#M459780 <HTML><HEAD></HEAD><BODY><P>Do you have a MonthNum field in your application?</P></BODY></HTML> Mon, 07 Aug 2017 14:41:23 GMT https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363464#M459780 sunny_talwar 2017-08-07T14:41:23Z Re: Calculating current month sales https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363465#M459781 <HTML><HEAD></HEAD><BODY><P>Yes I have FINMONTH</P></BODY></HTML> Mon, 07 Aug 2017 14:43:56 GMT https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363465#M459781 2017-08-07T14:43:56Z Re: Calculating current month sales https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363466#M459782 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum({&lt;FINMONTH = {'$(=vFINMNT)'}&gt;}Sales)</STRONG></P></BODY></HTML> Mon, 07 Aug 2017 14:45:48 GMT https://community.qlik.com/t5/QlikView/Calculating-current-month-sales/m-p/1363466#M459782 sunny_talwar 2017-08-07T14:45:48Z