topic Re: Auto select Max date in list box in QlikView

Auto select Max date in list box

chrismtb — Sat, 16 Nov 2024 01:29:46 GMT

Hi,

I have a list box with dates in.

As my dashboard publishes daily the list box updates with new dates.

I want my list box to select the most recent date available by default.

I think this should be simple but not sure how to do it!

Thanks

Taoufiq_Zarra — Thu, 16 Jan 2020 13:40:22 GMT

since you can't add actions to the lists.
I propose the following scenario:
1- in Sheet properties -> Trigger->OnActivateSheet->Edit Actions

2-Add->Select in Field->
Field: your date
Searching String: =Max(date)

with this the users automatically get the date selected.

chrismtb — Fri, 24 Jan 2020 10:07:06 GMT

I actually ended up putting the event trigger on the Document Open Actions rather than the sheet activate.

Also i had to use =MaxString(MyDate) rather than just Max as this didn't work initially.

Now working perfectly so thanks!