This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have sample input data as belowNeed 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
Add in workitemseqkey into the groupby statement. Should work if that is the key to identify each transaction.
How do you identify different windows of time? You have timestamp records in your table?
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
I do have timestamp
If I add workitemseqkey , then it would return min date and max date for each of the records