topic Re: How to make dimension show prev month dates in QlikView https://community.qlik.com/t5/QlikView/How-to-make-dimension-show-prev-month-dates/m-p/968211#M331712 <HTML><HEAD></HEAD><BODY><P>If(Dates&lt;MonthStart(today()) and Dates&gt;=MonthStart(today(),-1),Dates)</P></BODY></HTML> Thu, 01 Oct 2015 05:54:32 GMT Gysbert_Wassenaar 2015-10-01T05:54:32Z How to make dimension show prev month dates https://community.qlik.com/t5/QlikView/How-to-make-dimension-show-prev-month-dates/m-p/968210#M331711 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>how do i create a calculated dimension for dates to show for prev month if we on current&nbsp; max month</P><P>each month it must roll back by a full prev month.</P><P></P><P>or in the Expression if possible also, if maybe we want to sum sales.</P><P></P><P>e.g</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dates</STRONG></TH></TR><TR><TD style="padding: 2px;">2015/09/30</TD></TR><TR><TD style="padding: 2px;">2015/09/28</TD></TR><TR><TD>2015/08/12</TD></TR><TR><TD>2015/08/06</TD></TR><TR><TD>2015/08/04</TD></TR><TR><TD>2015/07/17</TD></TR></TBODY></TABLE><P></P><P>output should be:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dates</STRONG></TH></TR><TR><TD style="padding: 2px;">2015/08/12</TD></TR><TR><TD style="padding: 2px;">2015/08/06</TD></TR><TR><TD style="padding: 2px;">2015/08/04</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 30 Sep 2015 10:18:34 GMT https://community.qlik.com/t5/QlikView/How-to-make-dimension-show-prev-month-dates/m-p/968210#M331711 2015-09-30T10:18:34Z Re: How to make dimension show prev month dates https://community.qlik.com/t5/QlikView/How-to-make-dimension-show-prev-month-dates/m-p/968211#M331712 <HTML><HEAD></HEAD><BODY><P>If(Dates&lt;MonthStart(today()) and Dates&gt;=MonthStart(today(),-1),Dates)</P></BODY></HTML> Thu, 01 Oct 2015 05:54:32 GMT https://community.qlik.com/t5/QlikView/How-to-make-dimension-show-prev-month-dates/m-p/968211#M331712 Gysbert_Wassenaar 2015-10-01T05:54:32Z