topic Re: Wrong lastlogindate time in QlikView

Wrong lastlogindate time

nikhilgarg — Fri, 20 Mar 2015 08:50:27 GMT

Hey,

In my project , for a particular salesperson last login date time is coming as 5 days back although prject is running for him each day via autostart. For ex. For date: 19:03:2015 Lastlogindate showing is: 15.03.2015 and for 20.03.2015 it is showing 16.03.2015.

What can be the reason?

Thanks

Re: Wrong lastlogindate time

Gysbert_Wassenaar — Fri, 20 Mar 2015 09:06:43 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Wrong lastlogindate time

nikhilgarg — Fri, 20 Mar 2015 09:19:31 GMT

Actually , i cannt but when i fetch the data from database , it is also showing same last login date time as shown in dashboard. So where you think problem myt be?

Re: Wrong lastlogindate time

Gysbert_Wassenaar — Fri, 20 Mar 2015 09:24:20 GMT

No idea. Create an sql script to load sample data from the database. Execute that sql script directly on the database. Create a new qlikview document and use the same sql script to load the same sample data. Compare the two sets.

Re: Wrong lastlogindate time

buzzy996 — Fri, 20 Mar 2015 10:26:27 GMT

can u try,

1.first check how that date is populating? (systemdate/networkdate/database date)

2.check from point 1,whichever the date (systemdate/networkdate/database date) ur using is having latest date i.e 20.03.2015.

3. check that date having any dependences calculations

Re: Wrong lastlogindate time

nikhilgarg — Fri, 20 Mar 2015 10:31:25 GMT

Hey,

I checked that LastLoginDateTime column is loaded from SqlServerData. When i executed the query and fetch data from SqlServer for that particular salesperson , i see that same date is being shown as in dashboard. Which means in database also wrong date is being updated. Now what can i do for this ?

Re: Wrong lastlogindate time

buzzy996 — Fri, 20 Mar 2015 11:50:00 GMT

ya,tht's means no probelm with ur qlikview application.

so,just ask corresponding team (might be database team)? why the data is not upgrading?,tht is the solution to ur problem,tht's what i believe.

Re: Wrong lastlogindate time

nikhilgarg — Fri, 20 Mar 2015 11:54:02 GMT

Yeah , even i think the same

Re: Wrong lastlogindate time

buzzy996 — Fri, 20 Mar 2015 11:55:50 GMT

pls mark as correct,if ur happy with the solution!

Re: Wrong lastlogindate time

nikhilgarg — Fri, 20 Mar 2015 11:57:24 GMT

Btw this problem is happening with only 1 user. For all other users, last login date is working fine. So , is this something database team has to deal ?

Re: Wrong lastlogindate time

buzzy996 — Fri, 20 Mar 2015 12:02:18 GMT

I believe,as u said above if the date field value is coming from database ..tht should be reflect with all users!

can u check with couple of user before going to ask db team,tht helps..

Re: Wrong lastlogindate time

nikhilgarg — Fri, 20 Mar 2015 12:18:54 GMT

Yeah , Sure