Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fix selections fields on each sheet of my file .qvw

Hello everyone,

I try to fix the selection fields on each sheet of my file .qvw

I have thought about doing a right click on the selection field and check "always a selected value" so that when I close and then open my document, selection is not moving, thought it does not answer (well partially.... only on sheet number 1) to my problem. Indeed, the selection fields that I want to fix are not the same from one sheet to another.

Someone can help me?

Thank you in advance,

Prees

7 Replies
Chanty4u
MVP
MVP

u can use book mark for that..

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The easiest solutions is to use bookmarks. Use a bookmark for each sheet. Then add actions to the OnActivate and OnLeave triggers of the sheets. The action for the OnActivate trigger is an Apply Bookmark action to apply the relevant bookmark for the sheet. Use the OnLeave trigger in combination with a Replace Bookmark action to store the selections to the sheet bookmark on leaving the sheet.


talk is cheap, supply exceeds demand
Not applicable
Author

Ok thank you, it works when I use a bookmark for each sheet.

But what is the OnActivate and OnLeave triggers of the sheets ? Did you screenshots for example ?

Not applicable
Author

Ok thank you.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Right click a sheet and choose Properties to open the properties window of the sheet. Then go to the Triggers tab. You'll see two buttons that you can click to add actions to the triggers. When you click on one of the buttons a dialog opens where you can add actions to the trigger. Click the Add button. Then choose Bookmark in the left side listbox. Next choose Apply Bookmark (for the OnActivateSheet trigger) or Replace Bookmark (for the OnLeaveSheet trigger. Finally enter the bookmark id of the relevant bookmark. Click the OK buttons of the dialogs to apply the changes you've made.


talk is cheap, supply exceeds demand
Not applicable
Author

I want to make a bookmark for each sheet but it does not work. I realize that the bookmark I created is active for all the leaves and it's not what I wanted to do ... I would like to select a specific time period for one sheet, just one.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See my post above.


talk is cheap, supply exceeds demand