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