Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

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
dan_sullivan
Creator II
Creator II

create a variable (example:  vYesterdayCheck )

vYesterdayCheck = If([Date Inspected]=(Today()-1),'Yes','No')

Then filter on Yes and create a bookmark.

ahaahaaha
Partner - Master
Partner - Master

And it's still not possible in the standard Qlik Sense . After opening a bookmark, you must select it manually.

ahaahaaha
Partner - Master
Partner - Master

The only option is if the initial selection is always present in the user selections. Then you can make a bookmark and add it to Set Analysis expression as an additional selection to user selection.

beck_bakytbek
Master
Master

Elizabeth, look at this: like a triggers in Qlik View but in Qlik Sense

you need the extension for your issue

Beck

vijetas42
Specialist
Specialist

Please use document level triggers in QlikView,

in document properties go to tab triggers and OnOpen trigger by adding select in field with field name Date and value as Date(today()-1).

hammermill21
Creator III
Creator III
Author

Hi! Thank you, I have that extension downloaded but I can't get it to work with my date filter.

hammermill21
Creator III
Creator III
Author

I'm using Qlik Sense, but thank you.

beck_bakytbek
Master
Master

Hi Elizabeth,

look at this:

Beck

beck_bakytbek
Master
Master

eli.PNG

hammermill21
Creator III
Creator III
Author

That's the extension I have. I've attached my app. I'm trying to base the filter on the "Inspection Date" filter.