topic Re: how to open qvw file with latest year as selection in QlikView

how to open qvw file with latest year as selection

Wed, 08 Jan 2014 13:52:58 GMT

I have developed an application and now I want to get the current data to show up whenever I open my qvw file.like I was trying to get the latest year to show up but I am not able to get it.

I am going to document properties , under that I am going to triggers and in triggers I am selecting event trigger. i am using On open functionality and adding action through that for the latest year in field and string columns.

but this is not doing anything.

please advise me how I can add a purticular action to be performed when a document is opened.

Re: how to open qvw file with latest year as selection

Nicole-Smith — Wed, 08 Jan 2014 13:57:42 GMT

See the attached example. Screenshot of what I did is below:

Re: how to open qvw file with latest year as selection

Wed, 08 Jan 2014 14:01:59 GMT

it does not work..i tried this same thing

if there is any other way

Re: how to open qvw file with latest year as selection

Nicole-Smith — Wed, 08 Jan 2014 14:03:33 GMT

If it doesn't work, you need to post your .qvw file for us to see so we can figure out why yours is not working (there is no reason why it shouldn't work).

Re: how to open qvw file with latest year as selection

sundarakumar — Wed, 08 Jan 2014 14:05:14 GMT

Or you can try to create a bookmark which serves the same puropse.

Please post the sample app to better understand.

Re: Re: how to open qvw file with latest year as selection

Nicole-Smith — Wed, 08 Jan 2014 14:26:43 GMT

See the answer here: how to open qvw file with latest year as selection

You don't need to make multiple posts to upload a file. You could have edited your original post or put a new post with the file. In order to upload, you need to click "Use advanced editor", then there will be a link for attachment at the bottom.

First:

Then:

Re: how to open qvw file with latest year as selection

preminqlik — Wed, 08 Jan 2014 15:38:43 GMT

just follow the above step and write as following over select in Year field

=$(=max(year))