Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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
Partner

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
Partner

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