topic Re: How to show current month and previous in the same table with month as a dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059512#M354867 <HTML><HEAD></HEAD><BODY><P>What selections are you making?</P></BODY></HTML> Sun, 10 Jan 2016 16:09:19 GMT sunny_talwar 2016-01-10T16:09:19Z How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059505#M354860 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to show Current month Sales and previous month sales with the month as a dimension..</P><P></P><P>Its Urgent...</P><P>Please provide ur solution ASAP.</P></BODY></HTML> Sun, 10 Jan 2016 15:06:23 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059505#M354860 kavita25 2016-01-10T15:06:23Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059506#M354861 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check this..</P><P><A href="https://community.qlik.com/thread/198968">Show Today's Sales and Same Day Last Year's Sales</A></P><P>You can try to use with Above ()..</P></BODY></HTML> Sun, 10 Jan 2016 15:21:00 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059506#M354861 settu_periasamy 2016-01-10T15:21:00Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059507#M354862 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111151_Capture.PNG" style="height: 51px; width: 620px;" /></P><P></P><P>Expression for Previous Month:</P><P><STRONG>=Before(Sum(Act_Amt))</STRONG></P></BODY></HTML> Sun, 10 Jan 2016 15:49:15 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059507#M354862 sunny_talwar 2016-01-10T15:49:15Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059508#M354863 <HTML><HEAD></HEAD><BODY><P>I think you might not have opened the attachment. The chart used is a pivot table and required to use Before() function to get the previous value. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 10 Jan 2016 15:50:23 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059508#M354863 sunny_talwar 2016-01-10T15:50:23Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059509#M354864 <HTML><HEAD></HEAD><BODY><P>Yes.. I'm posted using my mobile.. thank you..</P></BODY></HTML> Sun, 10 Jan 2016 16:03:23 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059509#M354864 settu_periasamy 2016-01-10T16:03:23Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059510#M354865 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 10 Jan 2016 16:04:34 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059510#M354865 sunny_talwar 2016-01-10T16:04:34Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059511#M354866 <HTML><HEAD></HEAD><BODY><P>It doesnt work on selection....it gives null...</P></BODY></HTML> Sun, 10 Jan 2016 16:07:30 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059511#M354866 kavita25 2016-01-10T16:07:30Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059512#M354867 <HTML><HEAD></HEAD><BODY><P>What selections are you making?</P></BODY></HTML> Sun, 10 Jan 2016 16:09:19 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059512#M354867 sunny_talwar 2016-01-10T16:09:19Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059513#M354868 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P><STRONG>=If(Sum(Act_Amt) &gt; 0, Before(Sum({&lt;Month, [Month Year], Date, Year&gt;}Act_Amt)))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111174_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 10 Jan 2016 16:11:13 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059513#M354868 sunny_talwar 2016-01-10T16:11:13Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059514#M354869 <HTML><HEAD></HEAD><BODY><P>On click, its working now, But If its Jan it should show for Dec Previous Year...Now its showing null</P></BODY></HTML> Sun, 10 Jan 2016 16:36:24 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059514#M354869 kavita25 2016-01-10T16:36:24Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059515#M354870 <HTML><HEAD></HEAD><BODY><P>Check this:</P><P></P><P><STRONG>=If(Sum(Act_Amt) &gt; 0, If(Num(Month) &gt; 1, Before(Sum({&lt;Month, [Month Year], Date, Year&gt;}Act_Amt)), After(Sum({&lt;Month, [Month Year], Date, Year&gt;}Act_Amt), 11)))</STRONG></P></BODY></HTML> Sun, 10 Jan 2016 16:44:33 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059515#M354870 sunny_talwar 2016-01-10T16:44:33Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059516#M354871 <HTML><HEAD></HEAD><BODY><P>Thanks a lot..Sunny..</P><P>Really appreciate ur help.....</P><P>It worked.. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 10 Jan 2016 16:51:28 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059516#M354871 kavita25 2016-01-10T16:51:28Z Re: How to show current month and previous in the same table with month as a dimension https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059517#M354872 <HTML><HEAD></HEAD><BODY><P>Hello Sunny..</P><P></P><P>How will I restrict data for current month &amp; previous two months for the same table.</P><P></P><P></P><P>Plzz..help me with this.</P><P></P><P></P><P>Regards,</P><P>Kavita</P></BODY></HTML> Wed, 20 Jan 2016 10:57:47 GMT https://community.qlik.com/t5/QlikView/How-to-show-current-month-and-previous-in-the-same-table-with/m-p/1059517#M354872 kavita25 2016-01-20T10:57:47Z