Discussion Board for collaboration related to QlikView App Development.
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
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
Hope will help
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.
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
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.