topic Set Filters to a default Date Range in QlikView

Set Filters to a default Date Range

Wed, 06 Jul 2016 19:58:14 GMT

Hello,

I have a slider/Calendar Object on a dashboard. I would like this, by default, to show a specific date range. From my reading, it says i can possibly build a macros to do this, however I do not have any experience in building a macro in Qlikview. Is there an easier way to do this right in the slider/calendar properties?

Re: Set Filters to a default Date Range

sunny_talwar — Wed, 06 Jul 2016 21:44:44 GMT

You can use a on-open trigger to do this may be.

Re: Set Filters to a default Date Range

Thu, 07 Jul 2016 12:13:25 GMT

Thank you Sunny,

Are you able to provide me an example or point me to instructions on how to do this?

Re: Set Filters to a default Date Range

Anonymous — Thu, 07 Jul 2016 14:02:16 GMT

Included the video in powerpoint (2013) and example (qvw) as well

Re: Set Filters to a default Date Range

Thu, 07 Jul 2016 18:52:51 GMT

Thank you,

I see you have two calendar objects to show a date range, I want to show last week's date range on a slider by default. Is there a way I can do this?

Re: Set Filters to a default Date Range

boorgura — Thu, 07 Jul 2016 20:23:11 GMT

You can set the default range in the field as an "on open trigger".

document properties --> triggers tab --> Add an action for OnOpen Trigger

in the action --> select in Field --> specify the field name and appropriate selection criteria.

Re: Set Filters to a default Date Range

Fri, 08 Jul 2016 14:00:43 GMT

Thank you,

So the set up of my dashboard is as follows:

I have three tabs, all displaying data from different data sources. On each of the tabs, I need to show the date range of the week prior. Each data source has a different date field so I believe I will need to create three different triggers so each of the tabs opens up with the correct date range. Would that work?

Re: Set Filters to a default Date Range

boorgura — Fri, 08 Jul 2016 14:14:07 GMT

Instead of document trigger - you will have to do a sheet trigger.

Sheet Properties --> Triggers Tab

Re: Set Filters to a default Date Range

Fri, 08 Jul 2016 15:40:06 GMT

Thank you!

So my

Field under the add Action is 'Date'

And my Search String is:

=('>='& Date(WeekStart(Max(Date))) & '<=' & Date(WeekEnd(Max(Date))))

However this does not seem to work. I am not getting an error, however the filter is not automatically applied to the slider object.

Re: Set Filters to a default Date Range

boorgura — Fri, 08 Jul 2016 15:55:23 GMT

Try not using the &

Usually search string would be like this:

>=1/1/2016 <=2/28/2016

Re: Set Filters to a default Date Range

Fri, 08 Jul 2016 16:01:09 GMT

So I changed it to

=>= Date(WeekStart(Max(Date))) <=Date(WeekEnd(Max(Date)))

And it says 'Garbage after expression: 'Date'

Re: Set Filters to a default Date Range

sunny_talwar — Fri, 08 Jul 2016 16:26:38 GMT

How about this:

='>=' & Date(WeekStart(Max(Date))) & '<=' & Date(WeekEnd(Max(Date)))

Re: Set Filters to a default Date Range

harithadogiparthi505 — Fri, 23 Sep 2022 17:39:51 GMT

Hi sunny,

I have an issue working with qliksense setting date picker default range.

I have used the similar expression.

My dashboard consist of four sheets. When navigating from one sheet to next the default is setting correct.

While navigating back from second sheet to first show previous week data of default.

Is there any solution for this kind of issue.

Please help me with the solution.