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: 
Not applicable

Filter pane - Date Range?

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? 

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

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.

View solution in original post

5 Replies
Not applicable
Author

Try with an action trigger "select in field" on a button:

FieldDate= today()

FieldDate=today()-1

FieldDate= ">= addweeks(today(),-1) <=today()"

Not applicable
Author

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)

JonnyPoole
Employee
Employee

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.

Not applicable
Author

Cool idea!  Any guidance on doing Yesterday or This Week?  Maybe just point me to the relevant documentation on date functions?

JonnyPoole
Employee
Employee

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);

https://help.qlik.com/sense/en-US/online/#../Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/D...

https://help.qlik.com/sense/en-US/online/#../Subsystems/Hub/Content/Scripting/DateTimeInterpretation...


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