13 Replies Latest reply: Jan 4, 2012 7:18 AM by Thor Hansen RSS

    How to limit what is displayed in a YEAR list box

      My first post

      I have searched before posting, but I am a real rookie with Qlikview, so forgive me if I have not searched well enough.  It is probably because I do not know the terminology yet.

       

      We have transactions in our system going forward to 2015 due to accruals, but I do not want users to see or be able to select any YEAR into the future.

      How can I write an expression in a list box to only display years up until current year (2012)?

       

      Current YEAR selection:

      2007  2008  2009  2010  2011  2012  2013  2014  2015

       

      I wish the list box only to display:

      2007  2008  2009  2010  2011  2012

       

      Regards

      Thor