topic Re: QlikSense: search data for the last n days in App Development

QlikSense: search data for the last n days

PaoloGuerra — Sun, 16 May 2021 18:09:49 GMT

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)

Re: QlikSense: search data for the last n days

mato32188 — Sun, 16 May 2021 19:34:59 GMT

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.

Re: QlikSense: search data for the last n days

PaoloGuerra — Sun, 16 May 2021 20:29:46 GMT

Hi @mato32188 ,

i created some bookmarks, thanks !!

paolo (italy)