Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Pls guide me any one how i can achive this in qlikview
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.
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.
Hi,
see attached
Regards
Thanks.
It migt helpfull to me let me work on this.
Thanks