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: 
KevSan
Contributor II
Contributor II

filter data on previous day/week/month

Hi everybody,

 

I would like to create a filter pane with variables for filtering on previous day/week or month. How could it be done ? 

And how to put the yesterday filter automatically when opening the file ?

Does someone have an idea for me? Or another way to achieve it

 

Thanks in advance for your answer and have a nice day.

 

Labels (2)
1 Solution

Accepted Solutions
albertovarela
Partner - Specialist
Partner - Specialist

To apply the yesterday filter on opening, you could create a dynamic bookmark and set it up as default.

Identify the sheet to be the landing page,  if you already have a filter pane or table with the date field use the expression search: =yourfield=today()-1 and hit enter; if you don't have the field exposed then use the selections tool.  Then create the bookmark and set it up as default .

I hope this helps

View solution in original post

1 Reply
albertovarela
Partner - Specialist
Partner - Specialist

To apply the yesterday filter on opening, you could create a dynamic bookmark and set it up as default.

Identify the sheet to be the landing page,  if you already have a filter pane or table with the date field use the expression search: =yourfield=today()-1 and hit enter; if you don't have the field exposed then use the selections tool.  Then create the bookmark and set it up as default .

I hope this helps