Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

message Sequence

How I can achieve count of message Sequence that’s follows
same path like

StatusKey            Status   Statusdate

101         Sent       10/16/2012 9:00

102         Queued               10/16/2012 10:00

103         Open     10/16/2012 11:00

104         Msg Expired       10/16/2012 0:00

And duration between each
Sequence  I have attached sample
xls data and qvw file pls guide me how I can achieve this in qlikvew proper way
highly appreciated prompt response

5 Replies
srinivasa1
Creator II
Creator II
Author

Pls guide me any one how i can achive this in qlikview

Gysbert_Wassenaar

See attached qvw. Your example data has some weird data. The time for MsgExpired lies before the time of Sent. If that would be true no message would ever be sent. Same for Sent to vendor. I've sorted the data by messagekey and then by statuskey. If that's not correct you can adjust that yourself. For example if you need to sort on statusdate instead of statuskey.


talk is cheap, supply exceeds demand
srinivasa1
Creator II
Creator II
Author

Hi Gysbert.

I
would appreciate your time and input. MsgExpired never before the time of sent
for per message. I wold like to know how many message in same path(count of
message that follow same path) can you pls guide me in this.

Thanks
in advance.

Not applicable

Hi,

see attached

Regards

srinivasa1
Creator II
Creator II
Author

Thanks.

It migt helpfull to me let me work on this.

Thanks