Qlik Sense - Dynamic bookmarks not working with a variable

[Jul_K]

Hi all, 

I want to create a bookmark which is choosing automatically the current booking year and the current booking period. For that I have used the dynamic bookmark option by using the search functionality. 

In the data load editor I have created two variables which are calculating the current booking year and the current booking period depending on the date of today. For the booking year it is 'vGJ' and for the current booking year it is 'vPER_CUM_MAX'. 

In the search field for the relevant filter field I have entered the following:

1) Field GJ (=booking year):   =[GJ] = vGJ

2) Field Periode:  =[Periode] = vPER_CUM_MAX

Both filters are working and are selecting the correct value, for GJ it is selecting '2022' and for the Periode it is selecting '12'. 

Then I saved this selection as a bookmark and the result is this: 

The GJ has worked and is now dynamic but somehow the Periode is not dynamic, it is set to a fixed value. 

Can somebody pls help? I don't know where's the problem, actually I did the same for those two fields... The variable format is also the same for those two.. 

[MendyS]

Hi @Jul_K 

try to wrap the var with '$(var)' or with $'(=var)' 

[Jul_K]

Unfortunately that didn't solved the problem. 

Those expressions:

=[Periode] = '$(vPER_CUM_MAX)'

=[Periode] = '$(=vPER_CUM_MAX)'

are also leading to a fixed value in the bookmark.. 

[Madhab77]

Hi Jul_K,

Did you get the solution, I need the solution, I have similar requirement.

Thanks & Regards,

Madhab Sikder

[Jul_K · Accepted solution]

Hi Madhab, 

yes I have a solution to the problem. A guy from Qlik explained me that it is important to type in the formula within the "Selections" area and not in a filter pane on the sheet. That solved my problem. 

Kind regards

Julia

[Madhab77]

Hi Julia,

Its not working for me, I tried like this, but nothing happen when press ENTER after giving the following expression:

The field is year and I am providing =Year=$(vBookmarkYear) in the search for the Year, and when pressing ENTER it is not going ahead. (variable vBookmarkYear having current year)

Thanks & Regards,

Madhab Sikder

[Jul_K]

Try =[Year]=$(vBookmarkYear) and press enter. 

If you then see the correct selected year,  you know that it has worked. 

[Madhab77]

Hi Julia,

I tried as you said, but it did not work:

Thanks & Regards,

Madhab Sikder

[Brano]

For anyone still looking for a solution, following syntax worked for me in Selections area as Julia advised and Madhab was trying:

=Year=vBookmarkYear