topic Sorting Dimension Values in QlikView https://community.qlik.com/t5/QlikView/Sorting-Dimension-Values/m-p/151797#M29486 <HTML><HEAD></HEAD><BODY><P>If you switch your sorting to be Descending on that field, it should be the last 12. I don't know if there is a simple way to pull the last 12, but sort them in Ascending order.</P><P>A more versatile way to do this is to use Set Analysis on your expressions:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({DateField={'&gt;=$(=Max(DateField,12))'}&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 18 Feb 2010 15:41:37 GMT 2010-02-18T15:41:37Z Sorting Dimension Values https://community.qlik.com/t5/QlikView/Sorting-Dimension-Values/m-p/151796#M29485 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm a newbie on Qlikview so hopefully this is really easy to answer!</P><P>I'm bringing 2 years worth of data into a combo chart e.g. Apr-2008 to Mar-2010, but I actually only want to show the latest 12 months at one time i.e. April-2009 to Mar-2010. However when I check the Max Visible Number box and enter 12 on the presentation tab it brings back Apr-2008 to Mar-2009.</P><P>Is there an easy way to fix this?</P><P><BR />Thanks in advance</P></BODY></HTML> Thu, 18 Feb 2010 15:31:20 GMT https://community.qlik.com/t5/QlikView/Sorting-Dimension-Values/m-p/151796#M29485 2010-02-18T15:31:20Z Sorting Dimension Values https://community.qlik.com/t5/QlikView/Sorting-Dimension-Values/m-p/151797#M29486 <HTML><HEAD></HEAD><BODY><P>If you switch your sorting to be Descending on that field, it should be the last 12. I don't know if there is a simple way to pull the last 12, but sort them in Ascending order.</P><P>A more versatile way to do this is to use Set Analysis on your expressions:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({DateField={'&gt;=$(=Max(DateField,12))'}&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 18 Feb 2010 15:41:37 GMT https://community.qlik.com/t5/QlikView/Sorting-Dimension-Values/m-p/151797#M29486 2010-02-18T15:41:37Z