Create dynamic date look up based on todays date

Tue, 11 Sep 2012 18:12:45 GMT

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);

topic Create dynamic date look up based on todays date in QlikView