topic Re: message Sequence in QlikView

message Sequence

srinivasa1 — Fri, 19 Oct 2012 03:28:19 GMT

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

Re: message Sequence

srinivasa1 — Sat, 20 Oct 2012 21:59:26 GMT

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

Re: message Sequence

Gysbert_Wassenaar — Sun, 21 Oct 2012 09:52:38 GMT

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.

Re: message Sequence

srinivasa1 — Mon, 22 Oct 2012 03:59:44 GMT

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.

Re: message Sequence

Mon, 22 Oct 2012 04:35:53 GMT

Hi,

see attached

Regards

Re: message Sequence

srinivasa1 — Mon, 22 Oct 2012 16:47:21 GMT

Thanks.

It migt helpfull to me let me work on this.

Thanks