topic How to pass max function with url for selecting max year in a list box in QlikView

How to pass max function with url for selecting max year in a list box

Gopi_E — Sat, 16 Nov 2024 01:30:59 GMT

Hi All,

I need to pass max({1}field) with url for selecting max year in a list box.

I know how to pass static value like url&select=LB01,2018.

But I need dynamic way,

Please tell me how to do this

Thanks in advance

Re: How to pass max function with url for selecting max year in a list box

Kushal_Chawda — Tue, 14 Jan 2020 16:45:10 GMT

Is there any specific reason you want to add in URL, because you can add the same on "On Open app" trigger?

Re: How to pass max function with url for selecting max year in a list box

Gopi_E — Thu, 16 Jan 2020 04:01:52 GMT

Hi kush,

Thanks for response,

We are using Ajax so On Open triggers are not working.

Client need whenever open the document it Should open with max year selected.

Thank you.

Re: How to pass max function with url for selecting max year in a list box

Brett_Bleess — Wed, 12 Feb 2020 20:19:00 GMT

Thinking this may be a duplicate post, as I could have sworn I just ran across a similar post the other day. The other option would be to try to set things in a variable in the load script then base your expression off the variable in the app such that when the expression calcs when the app is opened, it sets things to the value in the variable.

Regards,
Brett