4 Replies Latest reply: Jul 5, 2011 2:45 AM by Rob . RSS

    Search year based on expression

      Hello community,

       

      I have a question about selecting a year based on todays date (QlikView v. 9 SR6).

      Here's the scenario: I have list box displaying a field named date_YYYY, containing the values 2008, 2009, 2010 and 2011.

      I would like to be able to highlight the year belonging to the date of exactly one month ago from today. To do this, I try to use an expression in the search box:  

       

      =Year(Addmonths(today(),-1))

       

      However, this selects all years instead of 1.

      Using the exact same expression as Text in a text object displays the year just fine, in case of today that's 2011.

      I' ve tried an alternative approach using dollar sign expansion and a variable containing the expression, but no results so far.

      Does anybody have an idea how to get this to work?

       

      Thanks,

       

      Robert