Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

session log analysis

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)

session log.png

Thanks

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: session log analysis

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

Regards,

Jagan.

View solution in original post

14 Replies
Highlighted
Partner
Partner

Re: session log analysis

the Problem is that you didnot use a function

use sum(SESSION_DURATION) should work

Highlighted
MVP & Luminary
MVP & Luminary

Re: session log analysis

Try sum(SESSION_DURATION) instead of just (SESSION_DURATION)


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

Re: session log analysis

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)

or

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


Best regards,

Christian

Highlighted
MVP & Luminary
MVP & Luminary

Re: session log analysis

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

Highlighted
MVP & Luminary
MVP & Luminary

Re: session log analysis

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

Regards,

Jagan.

View solution in original post

Highlighted
Specialist
Specialist

Re: session log analysis

Hi Kanimozhi,

Is Sum(SESSION_DURATION) working or not?

How are you calculating SESSION_DURATION field?

Highlighted
Contributor III
Contributor III

Re: session log analysis

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

Highlighted
Specialist
Specialist

Re: session log analysis

Hi,

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

Can you share your script?

Thanks,

Highlighted
Contributor III
Contributor III

Re: session log analysis

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