Solved: Re: Dynamic default bookmarks - Qlik Community

tomgury · ‎2021-05-04

Hello,

I have watched this video about dynamic default bookmarks: https://www.youtube.com/watch?v=tFyqOigqnUw.

I want to make a dynamic default bookmark with a date that is 1 day before the max date and up to the prior 30 days.

I have entered this formula into the search: "=Date >= Max(Date) - 30 < Max(Date) - 1."

This does not work as i don't get any values to filter.

when i enter this value: "=Date >= Max(Date) - 30", it works. but when i add "< Max(Date) - 1.", it's not working.

anyway i can add a default bookmark that selects the dates between max(date) - 1 and max(date) - 30?

Thanks,

Tom.

tresesco · ‎2021-05-07

Try like:

=Date >= Max(Total Date) - 30 AND Date< Max(total Date) - 1

View solution in original post

tomgury · ‎2021-05-04

Anyone?

Ruggero_Piccoli · ‎2021-05-07

Hi,

Try with

=Date >= (Max(Date) - 30) * Date < (Max(Date) - 1)

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

tresesco · ‎2021-05-07

Try like:

=Date >= Max(Total Date) - 30 AND Date< Max(total Date) - 1

Josh-Head-of-BI-HGreg · ‎2021-12-13

I am using a date picker and I don't know how to use this formula there.

Josh-Head-of-BI-HGreg · ‎2021-12-13

I am using a date picker and I don't know how to use this formula there.

SergioTres · ‎2023-03-22

Grande Ruggero!

Ruggero_Piccoli · ‎2023-03-22

Grazie Sergio @SergioTres ! E' un piacere risentirti 🙂

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.