Default set date range

[#1]

Hi All,

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?

THnak you

Regards,

Prajna

[alexandros17]

With a trigger,

go in settings->document properties -> trigger -> add (on Open)

[Anonymous]

you should use trigger. goto settings, Document Properties, Triggers and on open and define your trigger

for the required dates

hope that helps

[#4 · Accepted 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.

[bertdijks]

Example in which the selected Year is set to the year of last month:

[#6]

hi,

i created above variables

LET vMinDate = Date(Today()-7,'DD/MM/YYYY');

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?

Regards,

Prajna

[#7]

You have +7 to max date you only need that to say Today() not Today()+7

[#8]

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

Regards,

Prajna

[#9]

Hey, I am stuck on the same issue in Qlik Sense. Could you help me with it?

[bertdijks]

With the default selections in QlikSense this is not possible; maybe with certain extensions