Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sayadutt
Creator
Creator

Filter with latest value on Page open from web

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

 

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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

Add in the trigger you did in sheet properties.

 

Thanks and regards,

Arthur Fong