topic Re: Calculating Last & Current Month Sales in QlikView https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873949#M1003361 <HTML><HEAD></HEAD><BODY><P>Seems to be working once I put the variable definition in the application. Does this look like what you wanted?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89103_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 11 Jun 2015 12:39:49 GMT sunny_talwar 2015-06-11T12:39:49Z Calculating Last & Current Month Sales https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873946#M1003358 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>I am Currently using a Straight Table</P><P>Doing a resident load to choose top 10 sales for each Branch</P><P>But stuck in calculating Current Month Sales &amp; Last month Sales</P><P>Please Suggest</P></BODY></HTML> Thu, 11 Jun 2015 12:23:05 GMT https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873946#M1003358 2015-06-11T12:23:05Z Re: Calculating Last & Current Month Sales https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873947#M1003359 <HTML><HEAD></HEAD><BODY><P>I don't see this variable <STRONG>vMaxSalesDate</STRONG> in the variable overview. How do you define that variable?</P><P></P><P><STRONG>=Date(MONTHSTART(AddMonths(vMaxSalesDate, -1)))</STRONG></P></BODY></HTML> Thu, 11 Jun 2015 12:27:13 GMT https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873947#M1003359 sunny_talwar 2015-06-11T12:27:13Z Re: Calculating Last & Current Month Sales https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873948#M1003360 <HTML><HEAD></HEAD><BODY><P>HI Sunnindia</P><P></P><P>Sorry I missed it</P><P></P><P>vMaxSalesDate =Date(Max(DEC_Date))</P></BODY></HTML> Thu, 11 Jun 2015 12:32:42 GMT https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873948#M1003360 2015-06-11T12:32:42Z Re: Calculating Last & Current Month Sales https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873949#M1003361 <HTML><HEAD></HEAD><BODY><P>Seems to be working once I put the variable definition in the application. Does this look like what you wanted?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89103_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 11 Jun 2015 12:39:49 GMT https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873949#M1003361 sunny_talwar 2015-06-11T12:39:49Z Re: Calculating Last & Current Month Sales https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873950#M1003362 <HTML><HEAD></HEAD><BODY><P>HI </P><P></P><P></P><P>Yes, But still not showing any results on my original Qvw with the variables</P><P>Thank You For&nbsp; Pointing out</P></BODY></HTML> Thu, 11 Jun 2015 12:46:16 GMT https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873950#M1003362 2015-06-11T12:46:16Z Re: Calculating Last & Current Month Sales https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873951#M1003363 <HTML><HEAD></HEAD><BODY><P>May be caused by another problem? Not sure how to troubleshoot your sample when it is giving the output. You want to explain what is going wrong?</P></BODY></HTML> Thu, 11 Jun 2015 12:48:12 GMT https://community.qlik.com/t5/QlikView/Calculating-Last-Current-Month-Sales/m-p/873951#M1003363 sunny_talwar 2015-06-11T12:48:12Z