Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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
Employee
Employee

Re: Filter pane - Date Range?

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

Re: Filter pane - Date Range?

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

FieldDate= today()

FieldDate=today()-1

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

Not applicable

Re: Filter pane - Date Range?

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)

Employee
Employee

Re: Filter pane - Date Range?

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

Not applicable

Re: Filter pane - Date Range?

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

Employee
Employee

Re: Filter pane - Date Range?

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