Select Max Year when open the document

[Gopi_E]

Hi Qlikers,

how can i select max Year when document opens in qlikview without using op open document triggers. Because we are using Ajax, so on open document triggers not working.

Please give idea is there any other way we can do this,

Thanks in Advance

[praveenr035]

Unless you are running macros, the document/sheet "on open" triggers should work in both plug-in and AJAX versions.

Document Settings -> Triggers -> On Open (edit options) -> Add  Action (select in field) -> select field and max value

[Gopi_E]

Hi Praveen,

Thanks for your input.

We  did not use any macros and I tried this on open document triggers but we are using Ajax and we checked in access point. This document triggers not working..and we have a single sheet based dashboards..so sheet level triggers also not working.

Please tell me is there any other way to do this

Thanks in advance

[praveenr035]

You may refer this post:

It looks like you may need admin change to make the trigger work 

or

You may use search expression in URL to dynamically assign value and save it as bookmark

https://community.qlik.com/t5/New-to-QlikView/How-to-do-an-initial-selection-with-Ajax-and-Qlikview-...

[Gopi_E]

Hi Praveen,

Thanks for your response

I went through this link, 

but i am unable to find out solution, can you please give explanation  what exactly i have to do for displaying max year when open the doc with ajax

[Brett_Bleess]

Gopi, could you use a Let statement on a variable in the Script that would update on each load and then where you need that set, use the variable in the expression?

Regards,
Brett