How-to track user events with Qlikview?

[#1]

I have a db with all the user events of a web application - see below on th eleft the source table.

On the below image, I am trying to create the pivot on the right from the data on the left.

Can someone help me to create the formula that will compute:

- the number of sessions that start with Event Name 1

- the number of session that starts with Event Name 2

- the number of sessions wherre Event Name 1 is the second event made by a user

- ....

?

That would be wonderful help!

Million thanks for your answers!

[#2]

Hi

I created a field

• AutoNumber(Event_DateTime2,Session_Id) as NumEvent

in the script (to be loaded with the DB load)

Then in a pivot table, us the following formula:

• Count(If(Event_DateTime = Aggr(Nodistinct Min(Event_DateTime),Session_Id,NumEvent),Session_Id))

In the pivot you will have Event_EventName as the first dimension and NumEvent as the 2nd (pivoted to the top)

Please see attached for solution

Regards

Byron