Need help with showing data in

Tue, 07 Oct 2014 21:15:40 GMT

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

Selected Date	Active Items	Future Items	Terminated Items
1/1	A1, B1	C1
1/4	A1, B2	C1
1/6	A2	C1	B2
1/10	A3, C2		B2

Any help would be greatly appreciated. Thank you.

topic Need help with showing data in in QlikView

Need help with showing data in