topic onOpen time select lastdate in QlikView

onOpen time select lastdate

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I want to select last time on open time , How can i on my qvd file?

Thanks.

Re: onOpen time select lastdate

avinashelite — Fri, 06 Feb 2015 09:40:10 GMT

Hi Murat,

You want to select the last time on which field ???? or your trying to get the user last login time

Re: onOpen time select lastdate

Fri, 06 Feb 2015 09:59:53 GMT

Hi Avinash,

Thank you for your interest,

I want to see data on lastdate onOpen ,

If i select date field on last time ,Can ı see ?

Re: onOpen time select lastdate

avinashelite — Fri, 06 Feb 2015 10:05:00 GMT

see, if you are tracking and have date filed matching for it you can do.

NOTE: if your trying to see when the data when the user last login , this may not be possible

Re: onOpen time select lastdate

Fri, 06 Feb 2015 10:15:10 GMT

Hi,

Can you please specify your query a bit more ?

But as far as I could understand, you need the data as it was 'selected' before last close.

There are quite a few possibilities to it. One of them could be;

You have a Year, Month selected which can be stored in a variable.

This variable can be passed to the trigger in document settings OnOpen Event Trigger, like in the image below;

Thus, when you open the document next time, the last selected Month Year will be selected Default !

Hope it Helps!

Cheers !

Re: onOpen time select lastdate

Fri, 06 Feb 2015 10:16:26 GMT

I try to select date field (Start in my file) but ı cant,. I have date field but ı cant select lastdate or today

Re: onOpen time select lastdate

avinashelite — Fri, 06 Feb 2015 10:26:19 GMT

I check you file the reload date format and start column their is no match that's why its not selecting

try like this;

In the script

create one more column for start as below

load

start,

date(start,'DD-MM-YYYY') as match_date,

etc

then go to settings >trigger > on open> then select filed selection>select match_date

and in the value : date(reloadtime(),'DD-MM-YYYY')

this will do

Re: onOpen time select lastdate

Fri, 06 Feb 2015 11:54:18 GMT

Thank you so much Avinash.

Re: onOpen time select lastdate

avinashelite — Fri, 06 Feb 2015 12:02:39 GMT

No problem