The current issue that I am facing with QlikView is trying to show data in four different states based off one one filter. Here is a quick overview of the problem.
Each item has a "version number" and a start and end date for the version. Here is example data
Item
Version
Start Date
End Date
A
1
1/1
1/5
A
2
1/6
1/7
A
3
1/8
1/10
B
1
1/1
1/3
B
2
1/4
1/5
C
1
1/8
1/9
C
2
1/10
1/10
I want to have four different tables that show the data in the following states based off of a date selection:
Active: The items and version number that are active on that date
Future: The first version of each item that will be active at any point after the selected date
Terminated: The last version of each item that will no longer be active ( All end dates for all versions are before the date selection)
All Versions: All items and versions no matter the selection
Here are some example outputs based off of a date selection with the top table in mind
* If there is an entry in the column it means that it would be a row in the corresponding table.
* I did not put a column for all versions because it would be the equivalent to the data in the top table
