topic Re: Calculate average session time in QlikView

Calculate average session time

mr_novice — Wed, 17 Sep 2014 11:38:12 GMT

Hi All,

I have a simple table with these columns:

User, SessionDuration

A, 00:37:01

B, 01:40:02

.....

I would like to create a chart that shows the average session time vs the share/proportion of users. Y-axis shows average time and X-axis shows the proportion of users in % like this: 0% 10% 20%

Is this possible? How?

Thankful for any suggestion..

Chris

Re: Calculate average session time

mr_novice — Wed, 17 Sep 2014 13:43:19 GMT

Ok, another approach - I did this in a Straight Table:

Dimension - User

Expression: class(avg(SubField([Session Duration],':',1)*60+SubField([Session Duration],':',2)),10)

Now this gives me a table like this:

User, Range

A, 90<=x<100

B, 90<=x<100

C, 80<=x<90

Now I would like to count the users within each range so I get this:

Count(user), Range

2, 90<=x<100

1, 80<=x<90

How can I do this? I have been trying with "aggr"-funtion but I dont get it to work....

Any suggestions?

Re: Calculate average session time

JonnyPoole — Wed, 17 Sep 2014 13:46:27 GMT

I think to do that , your class expression would be the 'calculated dimension' and count(distinct [User]) would be the expression.

When used as a dimension you add the dimensional context using the aggr() function. Like this:

class( aggr( avg(SubField([Session Duration],':',1)*60+SubField([Session Duration],':',2)) , [User]) ,10)

Re: Calculate average session time

mr_novice — Wed, 17 Sep 2014 13:58:34 GMT

Thank you Jonathan. Works great! I did it wrong with the aggr() on the outside.