Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average of session actions

Hi everyone,

I have a problem with creating an average amount of actions done in sessions.

I want to be able to see the average amount of actions done in 1 session.
I´m loading data into my qvw from Qlikview Logfiles. Those logfiles contain sessions wich are used to determine

a time when somedone done something in qlikview.

I tried to use a function where I used "sum(count(Message))/count(Session_key)

The message counts the amount of things someone does during a session.
The Session_key is a primary key generated for every single session. In this way, all sessions are unique.

The function I tried to use didn't work because of a syntax error I think. And if I just use the

"count(Message)/count(Session_key)" function, then this will appear as average.

2017-01-24_13-51-17.png

I don't think this number is the right average of things someone does in one session.

Is there anyone who might know a solution to this?

Thanks in advance,

Ivo

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Avg(Aggr(Count(Message), Session_Key, Product))

View solution in original post

3 Replies
sunny_talwar

May be this:

Avg(Aggr(Count(Message), Session_Key, Product))

View solution in original post

Not applicable
Author

That was very quick and very helpful!
Thanks!!

sunny_talwar

It was just a random guess