Skip to main content

New to Qlik Sense

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tomgury
Contributor II
Contributor II

Dynamic default bookmarks

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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

View solution in original post

5 Replies
tomgury
Contributor II
Contributor II
Author

Anyone?

Ruggero_Piccoli
Support
Support

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
MVP
MVP

Try like:

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

Josh-Head-of-BI-HGreg
Contributor II
Contributor II

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

Josh-Head-of-BI-HGreg
Contributor II
Contributor II

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