On Open Dynamically Select Most Current Date in Date Dimension

[#1]

Anyone have a suggestion to select the most current date in a list box or multi-box when the application opens?

[#2]

Hi SPB ,

you can use a on open document trigger to select most current date.

you can trigger most current date by using select field trigger on you date coloumn

thanks

Meher

[#3]

I went to setup the trigger, but what is the correct item in select field.  I tried =Max(All Date) and that does not work.

[#4]

can you try Max(Date(ur date dimension))

thanks

Meher

[#5]

My Date Dimension is called "Date" but still does not seem to work. Do you have an example?

[#6]

I tried this expression in qlikview demo dashboard "Data visualisation" it worked fine

thanks

Meher

[#7 · Accepted solution]

check this attached document

thanks

Meher

[#8]

It must be a version 11 issue.  Does not work in V11.