1 Reply Latest reply: Apr 25, 2011 2:02 PM by Erich Shiino RSS

    Filter by Date

      I have a date field which is month day year. I want to see only those records where this date field is the in Inv Month and Inv Year selected. How would do that?

        • Filter by Date
          Erich Shiino

          Let's us say that your field is called DATE.

          at the end of the script you can make

          Load distinct DATE,

          MONTH(DATE) AS InvMonth,

          Year(DATE) as InvYear

          Resident YourTable

           

          Maybe QlikView didn't recognize your field as a date yet. So, if your field is MMDDYYYY, the script would be:

           

          Load distinct DATE,

          LEFT(DATE,2) AS InvMonth,

          right(DATE,4) as InvYear

          Resident YourTable