Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Search instead for
Did you mean:
Contributor III

## Dynamic Bookmark

Hello guys,

I have a - supposedly not that complex issue with creating a dynamic bookmark in Qlik Sense.

I created a bookmark manually: {<A2_Year={'2022','2023'}>}

How do I form this into a dynamic bookmark that shows me the current year plus the following year?

Please help me out

Labels (1)
• ### Script

1 Solution

Accepted Solutions
Champion III

As below

=A2_Year>=Year(Today()) AND A2_Year<=Year(Today())+1

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
13 Replies
Champion III

Search the below string in the field and hit enter

=A2_Year>=max(A2_Year,2)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Contributor III
Author

I tried searching for:
A2_Year>=max(A2_Year,2) and
=A2_Year>=max(A2_Year,2)

but unfortunately is does not work

MVP

Perhaps:

=A2_Year>=Year(Today())

Champion III

Confirm if the field A2_Year is actually numeric?

Does Searching  below returns results?

=A2_Year>=2021

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Contributor III
Author

Yes this syntax does work and gives me the dates from 2021 to 2025

Contributor III
Author

your syntax is giving me the following output:
It shows me the quartals

Contributor III
Author

I want to create a dynamic bookmark that showcases the current year and the next  year 🙂

Champion III

Confused!! Are we really working on a bookmark here?

Or just set analysis?

=Sum({<A2_Year={">=\$(=Year(today()))<=\$(=Year(today())+1)"}>} measurefield )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MVP

I'm fairly sure you're mixing up some things here. The syntax I provided simply selects all years that are >Year(Today()). I hadn't realized you had more years than just the next one, so you'd actually need e.g.

=A2_Year>=Year(Today())<=Year(Today())+1

This has nothing to do with whatever dimension you're using in your charts.

Tags