topic Dynamic Filter to filter by last /previous years in App Development

Dynamic Filter to filter by last /previous years

Qlikuser09 — Fri, 15 Nov 2024 20:54:35 GMT

=Year =Max(Year) works fine in filtering out max year

, but =Year =Max(Year) -1 or Year = {"$(=Max(Year) - 3)"} not filtering out anything giving me null values in Year filter

Re: Dynamic Filter to filter by last /previous years

MatheusC — Fri, 19 Jul 2024 17:48:45 GMT

@Qlikuser09

see it like this:

=FieldYear=$(=max(FieldYear)) -> current
=FieldYear=$(=max(FieldYear))-1 -> previous

or

=FieldYear=Year(Today()) -> currect
=FieldYear=Year(Today())-1 -> previous

- Matheus

Re: Dynamic Filter to filter by last /previous years

Qlikuser09 — Fri, 19 Jul 2024 19:47:49 GMT

thanks, the above formula (Year=Year(Today())-1)worked well for previous year to filter by . but i have data like below i wanted to filter by last three days or from current calendar date at midnight. what formula can be used in this case to filter by

{< DateField= {"=DateField>= Date(Today() - 2) and Datefield<= Date(Today())"} >} or

=[Datefield]<=$(=max(DateField))-1 is not working and rendering any results

Re: Dynamic Filter to filter by last /previous years

MatheusC — Fri, 19 Jul 2024 20:30:19 GMT

Cool, try this

=FieldDate>=today()-2 and FieldDate<today() -> Does not include today's date

=FieldDate>=today()-2 and FieldDate<=today() -> includes today's date

- Matheus

Re: Dynamic Filter to filter by last /previous years

Qlikuser09 — Wed, 24 Jul 2024 18:18:05 GMT

currently the "field Date" is not in the date format , is there way we could filter by the latest 3 dates without having to change the data model. (it works with only when filtered by year , but not with date or month)

Re: Dynamic Filter to filter by last /previous years

MatheusC — Thu, 25 Jul 2024 18:40:40 GMT

If you can incorporate it into the script by creating a new field, that would certainly be the best way. However, you can also insert this formatting into your search filter

=Date(Floor(TimeStamp#(FieldDateTime, 'DD/MM/YYYY hh:mm:ss TT')), 'DD/MM/YYYY')

Regards