Discussion board where members can get started with QlikView.
Whenever i open the document by default i want to show only those dates falling one week before and after the current date.
later on user can select his date range.
How can i restrict default selection?
Go to Solution.
In your load script add
LET vMinDate = Date(Today()-7,'DD/MM/YYYY');
LET vMaxDate = Date(Today(),'DD/MM/YYYY');
Set an on open trigger in the document settings and set field to select between that range.
With a trigger,
go in settings->document properties -> trigger -> add (on Open)
you should use trigger. goto settings, Document Properties, Triggers and on open and define your trigger
for the required dates
hope that helps
Example in which the selected Year is set to the year of last month:
i created above variables
LET vMaxDate = Date(Today()+7,'DD/MM/YYYY');
after that in document prop on open
took action ---> select in field----> datefield---->= '>=' vMinDate & '<=' & vMaxDate
but m not getting till only currnet date... why is it so?
You have +7 to max date you only need that to say Today() not Today()+7
yeah.. but i want data for one week before and one week after current date
em getting still the same if i use today() instead of today()+7
Hey, I am stuck on the same issue in Qlik Sense. Could you help me with it?
With the default selections in QlikSense this is not possible; maybe with certain extensions