Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Dynamic Bookmark

Hi Experts,

I have a requirement like when I click on "Dashboard"  button I have to navigate to Dashboard sheet and Max of Month in the Month field has to be selected dynamically in filter pane.

1. I have selected Month= Feb and created a Book mark

Feb bookmark.png

2. Then applied the bookmark in Sheet navigation extension to apply Feb selection in the navigation sheet automatically.

apply bookmark.png

Till now it works fine, but when March data refreshed the button navigation selecting Feb only in the Month field instead of March in the default filter. Is there any way to create dynamic book mark or is there any other way to apply default Max(Month)selection on particular sheet automatically by clicking on navigation button.

Please help me on this.

Thanks in advance.

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Which is this extension? And why do you want to apply a bookmark?

I am assuming the extension allows you to set a value for a field. see below screenshot i am using Sheet Navigation + Actions for Qlik Sense.

Capture.PNG

 

 

 

 

 

 

I dont believe you can do this directly with a bookmark. (there maybe a round about way but i will await your reply before suggesting that)

 

mikaelsc
Specialist
Specialist

would it work if you calculated this in your model 

(add a field _MaxMonth = 1 (for the latest month) and =0 for all the other month), on which you could create a filter/bookmark?

vikramv
Creator III
Creator III

Have you tried this ...

Dynamic Default Bookmark in Qlik Sense

 

Thanks.

Vikky