topic Re: Count of Path sequency in QlikView

Count of Path sequency

srinivasa1 — Thu, 18 Oct 2012 15:34:30 GMT

Hi,

Can any guide me i can achive same path(Msg status) sequence followed for MessageKey (ie1,2) and(3,4)

i need report on message followed same path and duration for each msg status a (ie time diffrence between sent,Queuied for msgkey1)

MessageKey Msg Status Msgdate

1 Sent 10/16/2012 9:00

1 Queued 10/16/2012 10:00

1 Open 10/16/2012 11:00

1 Msg Expired 10/16/2012 0:00

2 Sent 10/16/2012 9:00

2 Queued 10/16/2012 10:00

2 Open 10/16/2012 11:00

2 Msg Expired 10/16/2012 0:00

3 Sent 10/16/2012 9:00

3 Inprocess 10/16/2012 10:00

3 SENT TO VENDOR 10/16/2012 11:00

4 Sent 10/16/2012 9:00

4 Inprocess 10/16/2012 10:00

4 SENT TO VENDOR 10/16/2012 11:00

Appreciate your inputs.

Re: Count of Path sequency

Thu, 18 Oct 2012 15:46:24 GMT

Hi,

in ur load script:

Load

MessageKey,

MsgStatus,

MsgDate,

if(MessageKey=previous(MessageKey),MsgDate-previous(MsgDate)) as Duration

from table;

Regards

Re: Count of Path sequency

srinivasa1 — Thu, 18 Oct 2012 16:19:51 GMT

hi
Thanks for you immediate reply
i wanted know how many msg followed same path like count of below msg

MessageKey
1 Sent
1 Queued
1 Open
1 Msg Expired
MessageKey
2 Sent
2 Queued
2 Open
2 Msg Expired

Thanks and Appreciate your inputs.

Re: Count of Path sequency

srinivasa1 — Thu, 18 Oct 2012 16:46:06 GMT

Can any one pls help me i need count status for message that has same path.

Re: Count of Path sequency

whiteline — Thu, 18 Oct 2012 17:57:43 GMT

Hi.

You could use concat() function with Msgdate as a sort criteria to make a path string and then us it as dimension for counting.

Depending on your needs you can do it in script or in a chart.

Re: Count of Path sequency

srinivasa1 — Thu, 18 Oct 2012 18:02:00 GMT

Thanks for your reply.

Do you have any example i dint got properly

thanks

Re: Count of Path sequency

whiteline — Thu, 18 Oct 2012 18:14:34 GMT

I think you should explain what you need more clearly in this case.

What is the 'message path', and what do you want to count.

First you asked about duration then about counting.

And have you loaded your Msgdate properly ? (as numbers, not as just strings)

Re: Count of Path sequency

srinivasa1 — Thu, 18 Oct 2012 18:31:38 GMT

Thanks for your promt response. i need to know count of msg follow

Similar sequence and duration

between message flow see below ...i need to count the mesg have same flow like below (sent,

Queued ,Open, Msg Expired)and duration between flow ,

MessageKey Msg Status Msgdate

1 Sent 10/16/2012 9:00

1 Queued 10/16/2012 10:00

1 Open 10/16/2012 11:00

1 Msg Expired 10/16/2012 0:00

2 Sent 10/16/2012 9:00

2 Queued 10/16/2012 10:00

2 Open 10/16/2012 11:00

2 Msg Expired 10/16/2012 0:00

3 Sent 10/16/2012 9:00

3 Inprocess 10/16/2012 10:00

3 SENT TO VENDOR 10/16/2012 11:00

4 Sent 10/16/2012 9:00

4 Inprocess 10/16/2012 10:00

4 SENT TO VENDOR 10/16/2012 11:00

will be grat if your helping me in that

thanks

Re: Count of Path sequency

whiteline — Thu, 18 Oct 2012 18:42:33 GMT

Ok, as you didn't confess I suppose that you've loaded data properly.

Use this expression as calculated dimension:

=count([Msg Status], '-', Msgdate)

to get count use expression:

=count(distinct MessageKey)

to get duration of messages use expression:

=Sum(aggr(Max(Msgdate)-Min(Msgdate), MessageKey))

Re: Count of Path sequency

srinivasa1 — Thu, 18 Oct 2012 19:10:32 GMT

Thanks

I have tried but its not working can you create one qvw file and send it will more helpfull

thanks

Re: Count of Path sequency

srinivasa1 — Thu, 18 Oct 2012 21:00:03 GMT

has any idea how we can achive this one pls help me.waiting for some

Solution

Thanks in advance.