Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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

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

 
SergioTres
Partner - Contributor II
Partner - Contributor II

Grande Ruggero!

 

Ruggero_Piccoli
Support
Support

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.