topic Re: Limit dimension values shown in QlikView https://community.qlik.com/t5/QlikView/Limit-dimension-values-shown/m-p/445794#M571080 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use like this, If(Month(DateField) &lt;= Month(Today()), Month(DateField)) as Dimension</P><P></P><P>Hope that helps</P></BODY></HTML> Wed, 26 Sep 2012 19:00:20 GMT MayilVahanan 2012-09-26T19:00:20Z Limit dimension values shown https://community.qlik.com/t5/QlikView/Limit-dimension-values-shown/m-p/445793#M571079 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P></P><P>I would like to limit the dimension values shown, i.e. I don't want months greater than today's.&nbsp; Is there away to limit the last x dates shown.&nbsp; The values for up coming months aren't necessarily zero and we are actually still useing QV 10 on the server.&nbsp; Any thoughts?</P></BODY></HTML> Wed, 26 Sep 2012 18:56:52 GMT https://community.qlik.com/t5/QlikView/Limit-dimension-values-shown/m-p/445793#M571079 2012-09-26T18:56:52Z Re: Limit dimension values shown https://community.qlik.com/t5/QlikView/Limit-dimension-values-shown/m-p/445794#M571080 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use like this, If(Month(DateField) &lt;= Month(Today()), Month(DateField)) as Dimension</P><P></P><P>Hope that helps</P></BODY></HTML> Wed, 26 Sep 2012 19:00:20 GMT https://community.qlik.com/t5/QlikView/Limit-dimension-values-shown/m-p/445794#M571080 MayilVahanan 2012-09-26T19:00:20Z Re: Limit dimension values shown https://community.qlik.com/t5/QlikView/Limit-dimension-values-shown/m-p/445795#M571081 <HTML><HEAD></HEAD><BODY><P>Thanks Mayil,&nbsp; Just wondering if there was an simpler way that didnt need a calculated dim.</P></BODY></HTML> Wed, 26 Sep 2012 19:53:49 GMT https://community.qlik.com/t5/QlikView/Limit-dimension-values-shown/m-p/445795#M571081 2012-09-26T19:53:49Z