topic Re: session log analysis in QlikView

session log analysis

Anonymous — Thu, 09 Jul 2015 08:02:11 GMT

hi all

trying to get session duration. but im not getting it properly plz refer 'session duration(In Sec.)' column. if my 'no.of session' is more than 1 then i have to get total session duration for that user. Please advise.

Expressions used in below chart:

No. Of Session =COUNT(SESSION_START)

Session Duration (In Sec.)=(SESSION_DURATION)

Thanks

Re: session log analysis

Anonymous — Thu, 09 Jul 2015 08:05:28 GMT

the Problem is that you didnot use a function

use sum(SESSION_DURATION) should work

Re: session log analysis

Gysbert_Wassenaar — Thu, 09 Jul 2015 08:05:52 GMT

Try sum(SESSION_DURATION) instead of just (SESSION_DURATION)

Re: session log analysis

schlettig — Thu, 09 Jul 2015 08:06:38 GMT

you could use an aggregation function like avg:

avg(SESSION_DURATION)

that would be at least arithmetically correct.

Other thing would be, if you have a Session_End field you could calculate sum(Session_End - Session_End)

if you have a unique ID for each session put this in your dimension.

Best regards,

Christian

Re: session log analysis

jagan — Thu, 09 Jul 2015 08:06:57 GMT

Hi,

Try like this

=Num(TimeStamp#(SESSION_DURATION, 'hh:mm:ss')) * 24*60*60

Hope this helps you.

Regards,

Jagan.

Re: session log analysis

jagan — Thu, 09 Jul 2015 08:08:44 GMT

Try Sum(SESSION_DURATION) to get the sum of Session duration.

Regards,

Jagan.

Re: session log analysis

tyagishaila — Thu, 09 Jul 2015 08:48:12 GMT

Hi Kanimozhi,

Is Sum(SESSION_DURATION) working or not?

How are you calculating SESSION_DURATION field?

Re: session log analysis

Anonymous — Thu, 09 Jul 2015 08:53:55 GMT

hi tyagishaila

session duration is directly coming from session log file. if i am using Sum(SESSION_DURATION) is not giving correct result. so in script i am doing SESSION_DURATION * 86400 AS Ses_dur_in_sec, and doing in expression sum(Ses_dur_in_sec) then coming correct.

any idea how i can get this without doing it in seconds.

thanks

Re: session log analysis

tyagishaila — Thu, 09 Jul 2015 09:01:14 GMT

Hi,

If you try your *86400 in front end expression instead of script, then what happened?

Can you share your script?

Thanks,

Re: session log analysis

Anonymous — Thu, 09 Jul 2015 09:06:45 GMT

hi tyagishaila,

both giving me same answer anyways that seconds is ok.

but now i need to show this in 1 to 6 months and 7 to 12 months columns, as i am not very sure in interval match for months. is it possible to help me on this please

thanks

Re: session log analysis

tyagishaila — Thu, 09 Jul 2015 09:11:35 GMT

Atleast share image of chart/Table which actually you want.

Re: session log analysis

Anonymous — Thu, 09 Jul 2015 09:17:33 GMT

thanks for your reply

please find the attached chart for sample

mentioned my comments in red color. please help me to achieve thhis

thanks

Re: session log analysis

jagan — Thu, 09 Jul 2015 09:34:39 GMT

Hi,

In script arrive a new column like below and use it as dimension in Pivot table

LOAD

If(SESSION_START >= MonthStart(Today(), -5), MonthName(Today()) & ' to ' & MonthName(Today(), -5),

If(SESSION_START >= MonthStart(Today(), -17), MonthName(Today(), -6) & ' to ' & MonthName(Today(), -17),

'Other'))

FROM ------------

Hope this helps you.

Regards,

jagan.

Re: session log analysis

tyagishaila — Thu, 09 Jul 2015 09:44:05 GMT

Jagan's post will help you surely.

try it.. and let us know is it working or not.

Thanks,

Re: session log analysis

Anonymous — Thu, 09 Jul 2015 10:04:10 GMT

Hi Thanks alot its working