topic Auto select time frame at startup in QlikView

Auto select time frame at startup

Fri, 10 Sep 2010 13:09:35 GMT

Hi,

I'm trying to fix that my QV application will select a specified timerange at startup. Or something alike that mightdo the trick.

Within the QVW i have a field that is a combination of the year and week and ta year field

INCENTYR & '-' & [INWK] AS YearWeek,
INCENTYR AS Year

The goal is that from the current year, all weeks till the current week are automaticaly selected at QVW startup.

What is the best way to fix this issue?

Regards

Auto select time frame at startup

surender_mehta — Fri, 10 Sep 2010 13:45:08 GMT

Hi,

As i understand from your question...

If you are able to select the current year, the data corresponding to the same will reflect automatically, means the data for all the weeks of current will reflect.

Just right in actions

Select field Year

=Max(Year)..

Hope will help

Auto select time frame at startup

Fri, 10 Sep 2010 13:53:50 GMT

Hi,

I understand you. But the thing is, when I select the current year, it will light up all the weeks where data is available in this year.

But I only want the weeks light up till last week.

And this all automated when I start my QVW.

Regards.

Auto select time frame at startup

Fri, 10 Sep 2010 14:14:59 GMT

Here is some code that I use to select the previous 12 months of invoices by default which should give you some ideas:

' Set rolling 12 month period for invoice month/year

' Get beginning range month/year
FromDate=DateAdd("m",-12,Date)
FromY=Year(FromDate)
FromM=Month(FromDate)
if len(FromM) < 2 then FromM = "0" & FromM end if
RangeFrom=FromY & FromM

' Get to range month/year
ToDate=DateAdd("m",-1,Date)
ToY=Year(ToDate)
ToM=Month(ToDate)
if len(ToM) < 2 then ToM = "0" & ToM end if
RangeTo=ToY & ToM

ActiveDocument.Fields("mmm CCYY").Select ">=" & RangeFrom & "<=" & RangeTo

Regards,

Gordon

Auto select time frame at startup

Tue, 14 Sep 2010 19:33:44 GMT

Thanks for the code.

I'll will see what I can use from it. I think it's not exactly usefull for my problem when I intepret it the right way.

regards.