Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Default Filter Selection

Hello-

I wanted to be able to set the date filter to yesterday's date. Meaning when someone opens the app it is already set to showing data from yesterday unless they change the selection.

Can someone help me with this?

Thank you!

28 Replies
arvind_patil
Valued Contributor II

Re: Default Filter Selection

Hi Elizabeth,

As per my thinking you need extra add condition in each object's expression.

Date ={'date(Today())-1'}

Thanks,

Arvind Patil

zhadrakas
Valued Contributor

Re: Default Filter Selection

Create a Trigger on open that does this selection.

- Press STRG+ALT+D

- Go to "Triggers" tab

- Choose "On Open"

- Click "Add Actions"

- Click "Add"

- Choose "Select in Field"

- Create a Trigger like this:

regards

tim

dan_sullivan
Contributor II

Re: Default Filter Selection

Triggers are not an option in Qlik Sense unfortunately

hammermill21
Contributor II

Re: Default Filter Selection

Hello Tim,

I tried this with an extension ( see below) but it's not working. I can trigger it to a select specific building but not to work with the date.

Capture.JPG

ahaahaaha
Honored Contributor

Re: Default Filter Selection

Hi,

In the standard mechanism, Qlik Sense there are no such possibilities. May be use the bookmark at once after the opening?

Regards,

Andrey

hammermill21
Contributor II

Re: Default Filter Selection

Well, I found an extension that will do it but it's not working wit the date option.

dan_sullivan
Contributor II

Re: Default Filter Selection

There isn't an elegant way to do this.  One option is to create a bookmark based on a variable so that 'yesterday' always changing correctly each day.

Or you can look at using an extension that allows you to set a 'default value' for your filter.

hammermill21
Contributor II

Re: Default Filter Selection

Hi, thanks!

How would I set the bookmark to always open to "yesterday's" date?

beck110979
Valued Contributor III

Re: Default Filter Selection

Hi Elizabeth,

look at this: https://community.qlik.com/ideas/4722

i created the solution as default filter in qlik sense

I hope that helps

Beck