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.
SQL SELECT "release_calendar_id",
load Distinct release as release_name,
where release >= release_name -.1???????
I also need to link release_cycle with the following table
load distinct status as unresolved_status,
where match(status,'Closed', 'Deployed', 'Close Requested', 'Completed')=0 and not isnull(status);