0 Replies Latest reply: Sep 11, 2012 3:38 PM by Zhenya Virina RSS

    Create dynamic date look up based on todays date

      HI I am failry new to QlikView.

       

      I am trying to create a dynamic look up that will display information based on today's date. 

       

      I would like to apply the following criterias:

       

      1. Go back one release cycle based on today's date

      2. Display all future releases

       

      Here is what i am working with today.

       

      Release_Schedule_table:

      SQL SELECT "release_calendar_id",

          "release_end_date",

          "release_name"

      FROM test.dbo."rm_release_calendar";

       

      Release_Cycle:

      load Distinct release as release_name,

      release

      Resident Release_Schedule_table

      where release >= release_name -.1???????

       

      I also need to link release_cycle with the following table

       

      Unresolved_Items:

      load distinct status as unresolved_status,

           status

      resident _table

      where match(status,'Closed', 'Deployed', 'Close Requested', 'Completed')=0 and not isnull(status);