topic Re: Defaulting a multi box date value when opening a document in QlikView

Defaulting a multi box date value when opening a document

triciagdaly — Tue, 15 Jul 2014 22:05:07 GMT

I would like to default a multi box date value field to the weekstart of this week. I've looked into using a macro from OnActivateSheet Trigger but unable to get the syntax correct, and thinking there must be an easier way. Attached is a screen shot of the multi box properties, and a portion of the screen showing the two values. I'd like to default to the start of this week (07/14/2014) when opening the document.

Re: Defaulting a multi box date value when opening a document

Wed, 16 Jul 2014 03:53:49 GMT

Hi Tricia,

You can still add a "Select in Field" trigger to the OnActivateSheet.

Then under Field, type your date fieldname: Inv_RptWeek

and under Search String, type: =Date(WeekStart(Today()), 'M/D/YYYY')

Hope this helps.

Re: Defaulting a multi box date value when opening a document

PradeepReddy — Wed, 16 Jul 2014 05:15:40 GMT

1) While Opening a Document

Doc Properties-->Triggeres-->OnOpen-->SelectInField

FieldName : Date_Field

FieldValue: date(WeekStart(Date_Field))

2) On sheet Activation

SheetProperties-->Triggers-->OnActivateSheet--->SelectInField

FieldName : Date_Field

FieldValue: date(WeekStart(Date_Field))

Re: Defaulting a multi box date value when opening a document

triciagdaly — Wed, 16 Jul 2014 13:08:17 GMT

I tried this and when refreshing or opening the sheet, date is not appearing.

Re: Defaulting a multi box date value when opening a document

Wed, 16 Jul 2014 13:19:37 GMT

Could be a formatting of date issue.

Are your dates within this field formatted same way as provided in the search string ?