topic On Open Dynamically Select Most Current Date in Date Dimension in QlikView

On Open Dynamically Select Most Current Date in Date Dimension

Fri, 21 Oct 2011 21:54:35 GMT

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

Fri, 21 Oct 2011 22:01:20 GMT

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

Fri, 21 Oct 2011 22:05:58 GMT

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.

Fri, 21 Oct 2011 22:14:31 GMT

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

thanks

Meher

Fri, 21 Oct 2011 22:19:02 GMT

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

Fri, 21 Oct 2011 22:24:24 GMT

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

thanks

Meher

Fri, 21 Oct 2011 22:32:24 GMT

check this attached document

thanks

Meher

Sat, 22 Oct 2011 00:03:25 GMT

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