Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
create a variable (example: vYesterdayCheck )
vYesterdayCheck = If([Date Inspected]=(Today()-1),'Yes','No')
Then filter on Yes and create a bookmark.
And it's still not possible in the standard Qlik Sense . After opening a bookmark, you must select it manually.
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.
Elizabeth, look at this: like a triggers in Qlik View but in Qlik Sense
you need the extension for your issue
Beck
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).
Hi! Thank you, I have that extension downloaded but I can't get it to work with my date filter.
I'm using Qlik Sense, but thank you.
Hi Elizabeth,
look at this:
Beck
That's the extension I have. I've attached my app. I'm trying to base the filter on the "Inspection Date" filter.