QlikSense: search data for the last n days

[PaoloGuerra]

Hi everyone,

in my table I would like to search for data only for the last n days (example last day, last 3 days). I don't know how to set this filter.

I only understood that to search for a certain period of time I can do as indicated in the printscreen below:

How can I create a special filter to insert in the timestamps column?

Thanks for the help

paolo (italy)

[mato32188 · Accepted solution]

Hi @PaoloGuerra ,

you can use for instance <2021-05-16 23:59:59 >2021-05-14 00:00:00. It should work.

There is also another option to create bookmark. Type =Timestamp>=Today()-3 AND Timestamp<=Today() to you filter pane search line, then create and save bookmark. Once bookmark is selected, it dynamically selects last 3 days including today.

Thanks.

br

m

[PaoloGuerra]

Hi @mato32188 ,

i created some bookmarks, thanks !!

paolo (italy)