Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ecak2105
Contributor III
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)
1 Solution

Accepted Solutions
vinieme12
Champion III
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.

View solution in original post

13 Replies
vinieme12
Champion III
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.
ecak2105
Contributor III
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

Or
MVP
MVP

Perhaps:

=A2_Year>=Year(Today())

vinieme12
Champion III
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.
ecak2105
Contributor III
Contributor III
Author

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

Screenshot 2022-11-15 160235.png

ecak2105
Contributor III
Contributor III
Author

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

Screenshot 2022-11-15 160517.png

ecak2105
Contributor III
Contributor III
Author

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

Screenshot 2022-11-15 160847.png

vinieme12
Champion III
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.
Or
MVP
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.