Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for
Did you mean:
Contributor II

## Dynamic default bookmarks

Hello,

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
MVP

Try like:

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

7 Replies
Contributor II
Author

Anyone?

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

Try like:

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

Contributor II

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

Contributor II

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

Partner - Contributor II

Grande Ruggero!

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.