Default Filter Selection

[hammermill21]

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!

[arvind_patil]

Hi Elizabeth,

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

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

Thanks,

Arvind Patil

[zhadrakas]

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]

Triggers are not an option in Qlik Sense unfortunately

[hammermill21]

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.

[ahaahaaha]

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]

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

[dan_sullivan]

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]

Hi, thanks!

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

[beck_bakytbek]

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