topic Re. :Set default DATE or time period ????? in QlikView

Set default DATE or time period ?????

Wed, 09 Jun 2010 07:16:16 GMT

How i can set default Current Date or Time Period in my report/Dashboard ???????

Re. :Set default DATE or time period ?????

martin59 — Wed, 09 Jun 2010 07:38:55 GMT

Hello,

You have to use =today() or =now() functions in a text area.

Re. :Set default DATE or time period ?????

Wed, 09 Jun 2010 07:51:16 GMT

Thanks Martin , but i want it when i have to set for a default month ??????

Is there any possibility that report automatically starts up at default month ????/

Regards

Ashwin

Re. :Set default DATE or time period ?????

Wed, 09 Jun 2010 12:16:21 GMT

Dear All ,

Is there any option for getting default month on the report / dashboard..............???

I have tried but not getting it. i want to restrict my application to current month.

Regards

Ashwin

Re. :Re: Re. :Set default DATE or time period ?????

martin59 — Wed, 09 Jun 2010 14:48:53 GMT

Have you tried =Month(Today()) ?

Re. :Set default DATE or time period ?????

johnw — Sat, 12 Jun 2010 01:40:46 GMT

So you want to actually select the current month automatically? I've done this with macros that execute when you open the document. For example, this selects a bunch of fields and activates a particular sheet. It sets the month to the previous month. The current month wouldn't need the addmonths(...,-1). You might be able to do this with actions in 9.0. I haven't really used actions yet since we're officially on 8.5 still.

sub initialSelections()
ActiveDocument.GetField("Date Type").Select "Activity Date"
ActiveDocument.GetField("Month").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'MMM YY')")
ActiveDocument.GetField("Location").Select "PCM"
ActiveDocument.GetField("Show Weights In").Select "Tons"
ActiveDocument.GetField("Show Coating In").Select "oz/ft2"
ActiveDocument.GetSheet("Yields by Product").Activate
end sub