Filter with latest value on Page open from web

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a listbox which loads "Date" field. This field get refreshed everyday and today's date gets added to the list.

My requirement is:

When I open the page through ajax extension from browser, it should ALWAYS filter on the latest date from the Listbox (which is today).

I tried with selecting the max(Date) through "Select in Field" at onActivateSheet, but it does not solve my purpose. This sheet is the default main sheet which gets loaded when I open through browser.

If I go to any other sheet and come back to this sheet, then it works.

I want this to work when I load the main sheet as well (without doing the flip-flop between main and other sheets).

Thanks

Re: Filter with latest value on Page open from web

Arthur_Fong — Thu, 29 Aug 2019 01:39:08 GMT

Try to add a trigger in document properties > triggers > OnPostReload.

Add in the trigger you did in sheet properties.

Thanks and regards,

Arthur Fong

topic Re: Filter with latest value on Page open from web in QlikView

Filter with latest value on Page open from web

Re: Filter with latest value on Page open from web