Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As below
=A2_Year>=Year(Today()) AND A2_Year<=Year(Today())+1
Search the below string in the field and hit enter
=A2_Year>=max(A2_Year,2)
I tried searching for:
A2_Year>=max(A2_Year,2) and
=A2_Year>=max(A2_Year,2)
but unfortunately is does not work
Perhaps:
=A2_Year>=Year(Today())
Confirm if the field A2_Year is actually numeric?
Does Searching below returns results?
=A2_Year>=2021
Yes this syntax does work and gives me the dates from 2021 to 2025
your syntax is giving me the following output:
It shows me the quartals
I want to create a dynamic bookmark that showcases the current year and the next year 🙂
Confused!! Are we really working on a bookmark here?
Or just set analysis?
=Sum({<A2_Year={">=$(=Year(today()))<=$(=Year(today())+1)"}>} measurefield )
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.