topic Re: Select Max Year when open the document in QlikView

Select Max Year when open the document

Gopi_E — Sat, 16 Nov 2024 01:31:52 GMT

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

Re: Select Max Year when open the document

praveenr035 — Mon, 13 Jan 2020 14:45:15 GMT

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

Re: Select Max Year when open the document

Gopi_E — Mon, 13 Jan 2020 14:50:11 GMT

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

Re: Select Max Year when open the document

praveenr035 — Mon, 13 Jan 2020 15:08:27 GMT

You may refer this post:

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

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-server/td-p/276196

Re: Select Max Year when open the document

Gopi_E — Thu, 16 Jan 2020 06:13:49 GMT

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

Re: Select Max Year when open the document

Brett_Bleess — Tue, 11 Feb 2020 20:38:37 GMT

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