topic Re: Time Difference expression for particular rows in QlikView

Time Difference expression for particular rows

ankur_abhishek — Sun, 02 Jul 2017 02:42:18 GMT

Hi,

I want to create an expression to calculate how much time a particular user stay on a specific page.

I have attached a sample file.

i.e I want to know for a particular session id how much time user stay on login page & various other pages in mins .I am not able to achieve this.

Please help me in creating Expression.

Thanks

Ankur

Re: Time Difference expression for particular rows

ankur_abhishek — Sun, 02 Jul 2017 08:11:06 GMT

Please help me on this?

Re: Time Difference expression for particular rows

antoniotiman — Sun, 02 Jul 2017 08:28:40 GMT

Hi Ankur,

Dimensions :

user_name

session_id

Expression :

Max({<page_viewed={'Logout Page'}>} page_viewed_datetime)-
Min({<page_viewed={'Login Page'}>} page_viewed_datetime)

Regards,

Antonio

Re: Time Difference expression for particular rows

ankur_abhishek — Sun, 02 Jul 2017 08:47:43 GMT

Hi Antonio,

Thanks for your reply!

As per your expression, it will so the time diff btw login page & logout page. But I want the time difference btw the first page (e.g login page) user visit than with the second page (e.g landing page) and so on. So that i can calculate the time user stay on a particular page.

Here in data unique session ids are created wrt particular user & remain same until user logout.

Re: Time Difference expression for particular rows

antoniotiman — Sun, 02 Jul 2017 09:35:45 GMT

See Attachment.

Re: Time Difference expression for particular rows

ankur_abhishek — Mon, 03 Jul 2017 04:54:34 GMT

Hi Antonio,

Thanks for your reply & great work . But there is an error if I select a page from list box it is showing time as below screen shot marked in red.

Re: Time Difference expression for particular rows

antoniotiman — Mon, 03 Jul 2017 05:17:53 GMT

See Attachment.