I have sample input data as below
Need output as show in screen shot attached jpg file . I need to do this using QlikView script , any help is highly appreciated as I am running under tight deadline of project
What is the key to identify Maintenance green and Maintenance blue?
They have the same workitem but why they are categorized in different startdate and endDate?
Assume workitem can be used as the key,
apply min(date) and max(date) aggregation group by status and workitem:
Refer qvw attached for reference.
Thanks and regards,
Thanks Aurthur for Reply, Problem If I do Min and Max with group by WorkItem, Status
I may loose one record.
I need output as below, 2 separate records
The transactions are independent and business wants to see separate keys. WorkItem, WorkItemSeqKey together can be considered as key . Work Item can go maintenance during different window of times and business wants to see as 2 different records
|Input Data flow|
|Need Output as below|
Add in workitemseqkey into the groupby statement. Should work if that is the key to identify each transaction.
Assuming the input is always in the right order, I would try:
1. removing empty rec_status rows
2. If rec_status is *end, peek(date,-1) as start, date as end
3. remove *start rows
If I add workitemseqkey , then it would return min date and max date for each of the records