1 Reply Latest reply: Jul 20, 2012 4:37 AM by Wojciech Parzyszek RSS

    Filtering future months

      Hi, I'm relatively new at qlikview and I've been trying to filter future months to see if there's information saved in incorrect months (ex: It's impossible to spend money in October 2012 if we're in July 2012).

      I'd like to count the number of transactions made in future months of the same year. This is the formula I've been trying to use:

      =Count({<transaction_Year={"=year(Today())"},transaction_Month={">month(Today())"}>}Transaction)

      It works fine with the year, but when I try to filter greater months (transaction_Month has a numerical value) it just doesn't work. I don't get an error in the expression, but the numbers are all to zero.

       

      I would greatly appreciate any help.