This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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,
May be this:
Avg(Aggr(Count(Message), Session_Key, Product))
View solution in original post
That was very quick and very helpful! Thanks!!
It was just a random guess