topic Re: How to set a default date for Calendar object? in QlikView

How to set a default date for Calendar object?

Fri, 24 Jul 2009 01:02:38 GMT

Hi there.

Is there a way to set an initial/default date to the Calendar Object?

Ie. When I open up the .qvw file, Iike the Date to be pre-selected to TODAY's date?

Thank-you for your support.

- Simon.

How to set a default date for Calendar object?

Fri, 24 Jul 2009 01:49:24 GMT

Simon,

I don't believe there is a way to set default values for any field, including a calendar object, which is unfortunate. The only way I know of to accomplish what you want is to have a macro that makes that selection for you when the document loads, or when you enter a tab. I don't remember the exact syntax off the top of my head, but it is something like:

ActiveDocument.Fields("Date").Select today()

You may be able to do a similar thing with a bookmark, which would be preferable to a macro as macros are single-threaded.

hope this helps,

sjprows

How to set a default date for Calendar object?

Fri, 24 Jul 2009 01:58:14 GMT

Similar to sjprows' suggestion, you could use a Trigger instead of a macro. You could set a Trigger for OnOpen and make the Today() selection in your date field. I believe Triggers are the preferred solution to some of the issues with using macros. Triggers are only available in QlikView 9.

How to set a default date for Calendar object?

Fri, 24 Jul 2009 03:29:00 GMT

You can base your calendar value on a variable. e.g. TodayDateVar

This variable will be equal to today() (In variables window add TodayDateVar = Date(Today())
So when you open your application your variable will take your value.

How to set a default date for Calendar object?

Fri, 20 Jan 2012 19:06:40 GMT

Got a step by step procedure for this?

How to set a default date for Calendar object?

rwunderlich — Fri, 20 Jan 2012 20:09:31 GMT

http://qlikviewnotes.blogspot.com/2011/12/initial-selections-and-current.html

Re: How to set a default date for Calendar object?

Thu, 19 Sep 2013 15:04:16 GMT

I personally like the behavior of the below, but it depends on your reload frequency. It resets the slider to today's date with each reload. The user can then choose a different date between the min/max options. This looks like it's working for me, but if there is a different better option, please reply.

in the load script:

LOAD
Min(BDate) as MinDate,
Max(EDate) as MaxDate
RESIDENT your table;

LET vMinDate = Num(Peek('MinDate', 0, 'MinMax'));
LET vMaxDate = Num(Peek('MaxDate', 0, 'MinMax'));
LET vToday = today();

In the calendar slider properties:

Set variable = vToday

set min and max equal to vMinDate and vMaxDate

Re: How to set a default date for Calendar object?

preminqlik — Thu, 31 Oct 2013 11:44:01 GMT

it is simple, by assigning calendar object variable to reload time date and saving the application.

For eg:

vCalendarDate=date (reload ())

(And giving the max value of calendar object to date of reload time)

Re: How to set a default date for Calendar object?

timmarsh — Wed, 10 Aug 2016 04:48:42 GMT

EDIT: Found the problem. Source data date field is a timestamp. I hadn't added floor to the date, so was being stored with timestamps but was not displaying with times.

===

Hi Rob, QV learner here.

That link worked for me, however, it removed all entries from the table except for a single matched instance of the day I wanted (yesterday).

I do have a key, 2 in fact, but I seem to lose the relationship between those dates.

I do have a master calendar.

If I add 2 select fields for month and day, and manually choose yesteErday, again, I lose table entries except one instance.

Am using a table box as it is supporting data