topic Re: Default set date range in QlikView

Default set date range

Wed, 23 Apr 2014 12:53:04 GMT

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

Re: Default set date range

alexandros17 — Wed, 23 Apr 2014 12:55:59 GMT

With a trigger,

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

Re: Default set date range

Anonymous — Wed, 23 Apr 2014 12:56:49 GMT

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

for the required dates

hope that helps

Re: Default set date range

Wed, 23 Apr 2014 12:58:13 GMT

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.

Re: Default set date range

bertdijks — Wed, 23 Apr 2014 13:01:59 GMT

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

Re: Default set date range

Wed, 23 Apr 2014 13:31:19 GMT

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

Re: Default set date range

Wed, 23 Apr 2014 13:33:25 GMT

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

Re: Default set date range

Wed, 23 Apr 2014 13:39:32 GMT

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

Re: Default set date range

Fri, 02 Jun 2017 21:41:09 GMT

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

Re: Default set date range

bertdijks — Fri, 07 Dec 2018 10:39:01 GMT

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