Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there some built in functionality I'm missing that would allow a user to quickly filter by "Today" or "Yesterday" or "Last Week" etc?
Hi Scott - i had an idea for this. FYI - triggers/buttons are not supported in Sense , just QlikVIew.
Here is my idea:
You can add a small table to the data model that joins to your ‘Date’ field . Something like this:
TodaysDate:
Load
Today() as Date,
'Filter Today' as TodayDate
Autogenerate 1;
Then add a filter pan for 'FilterToday'. When a user selects it, the dashboard will filter dynamically for Today. Keep in mind that Today would actually be the date when the document was last loaded.
Try with an action trigger "select in field" on a button:
FieldDate= today()
FieldDate=today()-1
FieldDate= ">= addweeks(today(),-1) <=today()"
I'm having trouble finding documentation on buttons and triggers in Qlik Sense. Can you point me in the right direction? Everything I have found is QlikView related and doesn't seem to apply (I don't really know the difference)
Hi Scott - i had an idea for this. FYI - triggers/buttons are not supported in Sense , just QlikVIew.
Here is my idea:
You can add a small table to the data model that joins to your ‘Date’ field . Something like this:
TodaysDate:
Load
Today() as Date,
'Filter Today' as TodayDate
Autogenerate 1;
Then add a filter pan for 'FilterToday'. When a user selects it, the dashboard will filter dynamically for Today. Keep in mind that Today would actually be the date when the document was last loaded.
Cool idea! Any guidance on doing Yesterday or This Week? Maybe just point me to the relevant documentation on date functions?
Maybe something like this in the same vein ?
SpecialDates:
Load
Today() as Date,
'Filter Today' as SpecialDate
Autogenerate 1;
concatenate (SpecialDates)
Load
Today()-1 as Date,
'Filter Yesterday' as SpecialDate
Autogenerate 1;
concatenate (SpecialDates)
Load
Date,
'This Week' as SpecialDate
resident <existing loaded table with Dates>
where weekname(Today)=weekname(Date);
You may be able to apply these techniques to build the samebuckets with the new Date/Time derived fields Load script methods.
https://help.qlik.com/sense/en-US/online/#../Subsystems/Hub/Content/Scripting/DerivedFields.htm