13 Replies Latest reply: Oct 24, 2010 11:09 AM by KaliPres RSS

    how to create month and year list box?

    KaliPres

      Hi,

      I am VERY new to Qlikview and can't seem to find figure out how to build a list box that ONLY shows "Month" and another box that should "Year".

      For example,

      My field records for date column are:

      2/01/2009

      2/14/2009

      3/12/2009

      4/15/2009

      1/10/2010

      2/23/2010

      3/02/2010

       

      How do I create a list box that ONLY shows "YEAR" such as only 2009, 2010?

      How do I create a list box that ONLY shows "Month" such as Jan, Feb, Mar, April?

       

      Thanks in advance!!!!