topic Chart display on date range condition in QlikView https://community.qlik.com/t5/QlikView/Chart-display-on-date-range-condition/m-p/214488#M68035 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P>How can I customize my Dimension statement to display only value in the previous month?</P><P>I tried</P><P>=</P><BR /><BR /> <P>IF(max(date(Mydate)) &gt;=monthstart(today(),-1) AND max(date(Mydate)) &lt;= monthend(today(),-1),SomeNames)</P><P>but its not working I'd really appreciate any help with this.</P><P></P><P>Thanks</P><P>AO</P><P></P></BODY></HTML> Tue, 13 Oct 2009 06:40:47 GMT 2009-10-13T06:40:47Z Chart display on date range condition https://community.qlik.com/t5/QlikView/Chart-display-on-date-range-condition/m-p/214488#M68035 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P>How can I customize my Dimension statement to display only value in the previous month?</P><P>I tried</P><P>=</P><BR /><BR /> <P>IF(max(date(Mydate)) &gt;=monthstart(today(),-1) AND max(date(Mydate)) &lt;= monthend(today(),-1),SomeNames)</P><P>but its not working I'd really appreciate any help with this.</P><P></P><P>Thanks</P><P>AO</P><P></P></BODY></HTML> Tue, 13 Oct 2009 06:40:47 GMT https://community.qlik.com/t5/QlikView/Chart-display-on-date-range-condition/m-p/214488#M68035 2009-10-13T06:40:47Z Chart display on date range condition https://community.qlik.com/t5/QlikView/Chart-display-on-date-range-condition/m-p/214489#M68036 <HTML><HEAD></HEAD><BODY><P>QV has a month function that can be used:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">If(Month(Mydate) = Month(Today())-1,SomeNames)</PRE></BLOCKQUOTE><BR /><BR /> <P>The "-1" in the later part is to get the previous month.</P></BODY></HTML> Tue, 13 Oct 2009 19:04:02 GMT https://community.qlik.com/t5/QlikView/Chart-display-on-date-range-condition/m-p/214489#M68036 vupen 2009-10-13T19:04:02Z