Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

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.

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


Community Browser