topic Re: How to restrict values with in a dimension in the chart itself in QlikView https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60357#M781968 <HTML><HEAD></HEAD><BODY><P>Try like this in dimension</P><P>=if(date(date#([Report Month],'MMMMM YYYY'),'MMMMM YYYY')&gt; 'March 2017', [Report Month])</P></BODY></HTML> Wed, 21 Mar 2018 07:43:17 GMT shiveshsingh 2018-03-21T07:43:17Z How to restrict values with in a dimension in the chart itself https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60355#M781966 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I have the below bar chart, In the report month dimension here I want it to show values that are greater than March 2017 (&gt; March 2017). How can I achieve that?</P><P></P><P><IMG alt="report month limit.jpg" class="jive-image image-1" src="/legacyfs/online/196956_report month limit.jpg" style="height: auto;" /></P><P></P><P></P><P>FYI I tried standard dimension limit chart property options that don't seem to work and server the purpose. Also, limiting data in load script thru where clause is not working or not an option here for me.</P><P></P><P>Thanks,</P><P>Gaurav</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60355#M781966 khigaurav999 2020-11-25T16:16:04Z Re: How to restrict values with in a dimension in the chart itself https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60356#M781967 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have you tried with Set Analysis?</P><P></P><P>Saludos.</P></BODY></HTML> Wed, 21 Mar 2018 07:37:09 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60356#M781967 fvelascog72 2018-03-21T07:37:09Z Re: How to restrict values with in a dimension in the chart itself https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60357#M781968 <HTML><HEAD></HEAD><BODY><P>Try like this in dimension</P><P>=if(date(date#([Report Month],'MMMMM YYYY'),'MMMMM YYYY')&gt; 'March 2017', [Report Month])</P></BODY></HTML> Wed, 21 Mar 2018 07:43:17 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60357#M781968 shiveshsingh 2018-03-21T07:43:17Z Re: How to restrict values with in a dimension in the chart itself https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60358#M781969 <HTML><HEAD></HEAD><BODY><P>No not yet.</P></BODY></HTML> Wed, 21 Mar 2018 07:57:17 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60358#M781969 khigaurav999 2018-03-21T07:57:17Z Re: How to restrict values with in a dimension in the chart itself https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60359#M781970 <HTML><HEAD></HEAD><BODY><P>Use the Calculated Dimension option and try below in Dimension definition :</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=if(date(date#([Report Month],'MMMMM YYYY'),'MMMMM YYYY')&gt; 'March 2017', [Report Month])</SPAN></P></BODY></HTML> Wed, 21 Mar 2018 08:24:15 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-values-with-in-a-dimension-in-the-chart-itself/m-p/60359#M781970 Anonymous 2018-03-21T08:24:15Z