Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
2. Then applied the bookmark in Sheet navigation extension to apply Feb selection in the navigation sheet automatically.
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.
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.
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)
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?