Dynamic Bookmark

[ecak2105]

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

[vinieme12]

Search the below string in the field and hit enter 

=A2_Year>=max(A2_Year,2)

[ecak2105]

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

but unfortunately is does not work

[Or]

Perhaps:

=A2_Year>=Year(Today())

[vinieme12]

Confirm if the field A2_Year is actually numeric?

Does Searching  below returns results?

=A2_Year>=2021

[ecak2105]

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

 

 

 

[ecak2105]

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

[ecak2105]

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

 

 

[vinieme12]

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

Or just set analysis?

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

[Or]

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.