topic Re: Default Date in Selection List in QlikView

Default Date in Selection List

Mon, 20 May 2013 14:56:27 GMT

I have a Date labeled TimePeriod that I am using in a selection list. I want the default selection to be the most recent date.

I am using this syntax and not sure what I am doing incorrect. Any guidance would be appreciated.

Tigger

OnActivateSheet

Edit Actions

Action=>Select In Field

Field => TimePeriod

Search => =date(max("TimePeriod"))

Not working!!!

Re: Default Date in Selection List

Mon, 20 May 2013 14:58:57 GMT

use this:

date(max({1}TimePeriod))

Re: Default Date in Selection List

Tue, 21 May 2013 00:46:50 GMT

did u try that.....??

Re: Default Date in Selection List

Tue, 21 May 2013 00:55:58 GMT

i did but it isnt working....

no dates are selected with the page is activated

Re: Default Date in Selection List

Tue, 21 May 2013 01:01:28 GMT

try putting that in the text first...and see what is the format u get.

this format shud be the same as ur date format of the field TimePeriod.

can u post ur format here ?

Re: Default Date in Selection List

Tue, 21 May 2013 01:09:46 GMT

MM/DD/YYYY

Re: Default Date in Selection List

Tue, 21 May 2013 04:15:59 GMT

=date(max({1}TimePeriod),'MM/DD/YYYY')

Re: Default Date in Selection List

sivarajs — Tue, 21 May 2013 04:58:33 GMT

try this macro

declare vMaxDate=max(TimePeriod)

sub test

set x= ActiveDocument.GetField("TimePeriod")

maxDate = ActiveDocument.Variables("vMaxDate").GetContent.String

x.Select maxDate

end sub

Re: Default Date in Selection List

Tue, 21 May 2013 10:38:51 GMT

That worked! Thank you!

Re: Default Date in Selection List

Tue, 21 May 2013 10:50:09 GMT

gr8....pls mark answered

Cheers!!!