Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set up a bookmark to control visibility of sheets - mixed with preselected values in fields

Hi,

sorry for that confusing subject.- it is hard to describe in one sentence what the issue is.

I have a single application that consists of two modules. Both are integrated into Salesforce, each of them has an own tab there. When clicking on the tab 'A', a bookmark of module 'A' of my application is applied and only certain sheets are shown.

For example, when clicking 'A', only the sheets '1' and '2' are visible, when clicking 'B' only sheet '3' is visible.

This is realized by a hidden Inputbox, that contains a variable called ACCOUNT_VIEW. Depending on its value ('0' or '1'), the sheets of either 'A' or 'B' are displayed, and that variable value is stored in the bookmark. Working fine so far.

Now I implemented two date related filter Listboxes (for the month and the fiscal year) and added OnOpen triggers for the document that shall preselect the current month and FY (in module 'B'). This is working fine, too, But now I discovered, that those two field values are stored in the bookmark of 'B', too. After the month changed, the month still stays May and not changes to June, so I assume that the stored bookmark value overrides the trigger.

Initially, I checked the 'Include Selections in bookmarks' option and I assume that this is causing the issue. I didn't check the 'Make bookmarks apply on top of current selection' by the way.

If I create new bookmark and uncheck the 'Include Selections in bookmarks' option, the control of the visibility ('A' vs 'B') does not work anymore, meaning 'B' does not do anything.

Hope that my issue is understandable from the text... 😕

12 Replies
Not applicable
Author

I need a) the ACCOUNT_VIEW variable to be set to a different value, so that when calling the 'Main' bookmark only the main sheet is shown and when calling the 'Sheet1' bookmark, only the 'Sheet1' is shown. And b) the current month shall be preselected on Sheet1.

The combination won't work, either calling the 'Sheet1' bookmark will not hide the main sheet and show 'Sheet1', or the 'Abschlusstermin' on 'Sheet1' is not preselected like in my example.

tresesco
MVP
MVP

Hi Jens Zibell,

Understood the issue. I guess it could be an SR version issue. I was playing with various BM options in SR5 and SR6 and I have serious doubt that all the bookmark features work properly in these SRs as stated in the manual. I suggest to have a word with qlik support team.

Not applicable
Author

Ok thanks, I'll contact the support then. If the answer is worth to be shared, I'll post it here.