Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

Community Browser