topic Re: Sales in QlikView https://community.qlik.com/t5/QlikView/Sales/m-p/638628#M1088504 <HTML><HEAD></HEAD><BODY><P>Try with</P><P></P><P>Current sales</P><P>=SUM({$&lt;Date2 = {'&gt;=$(=Max(Monthstart(Datefield))) &lt;=$(=Today())'}&gt;}Sales)</P><P></P><P>Previous Year</P><P>=SUM({$&lt;Date2 = {'&gt;=$(=Max(MonthStart(AddMonths(Datefield,-12)))) &lt;=$(=MonthEnd(AddMonths(Today(),-12)))'}&gt;}Sales)</P></BODY></HTML> Wed, 04 Jun 2014 06:27:17 GMT its_anandrjs 2014-06-04T06:27:17Z Sales https://community.qlik.com/t5/QlikView/Sales/m-p/638625#M1088501 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>&nbsp; I want to know the expression for :&nbsp;&nbsp;&nbsp; Current selected month sales VS previous Years current month sales </P><P></P><P> Can any one help me out </P><P></P><P></P><P> Thanks in Advance </P></BODY></HTML> Wed, 04 Jun 2014 06:09:36 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/638625#M1088501 2014-06-04T06:09:36Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/638626#M1088502 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>go through the attached document.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 04 Jun 2014 06:17:37 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/638626#M1088502 ashfaq_haseeb 2014-06-04T06:17:37Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/638627#M1088503 <HTML><HEAD></HEAD><BODY><P>Read this<A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd"> : Year-over-Year Comparisons</A><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd"></A></P></BODY></HTML> Wed, 04 Jun 2014 06:26:49 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/638627#M1088503 tresB 2014-06-04T06:26:49Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/638628#M1088504 <HTML><HEAD></HEAD><BODY><P>Try with</P><P></P><P>Current sales</P><P>=SUM({$&lt;Date2 = {'&gt;=$(=Max(Monthstart(Datefield))) &lt;=$(=Today())'}&gt;}Sales)</P><P></P><P>Previous Year</P><P>=SUM({$&lt;Date2 = {'&gt;=$(=Max(MonthStart(AddMonths(Datefield,-12)))) &lt;=$(=MonthEnd(AddMonths(Today(),-12)))'}&gt;}Sales)</P></BODY></HTML> Wed, 04 Jun 2014 06:27:17 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/638628#M1088504 its_anandrjs 2014-06-04T06:27:17Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/638629#M1088505 <HTML><HEAD></HEAD><BODY><P>Thanks ASFAQ ur suggetion worked thanks a lot friend </P></BODY></HTML> Wed, 04 Jun 2014 07:22:52 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/638629#M1088505 2014-06-04T07:22:52Z