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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Harish_Qlik
Contributor II
Contributor II

how to retain same selection from previous sheet

Hi..

I have multiple tabs(sheets) in my app, my client wants to keep the same selections when move between the sheets unless there is details selection set in sheet actions,

example: i have sheet1 and sheet2, when i land in Sheet1 1st time i should see my reporting month selected by default, and if i change the selections  and then moved sheet2 the same selection should carried forward to sheet2, is it possible?

Labels (2)
3 Replies
diegozecchini
Specialist
Specialist

Hi!
in Qlik Sense, selections are global by default, meaning that if you make a selection on one sheet, it will be retained when you navigate to another sheet but keep in mind that if you have any Sheet Actions that modify selections (like "Clear All Selections" or "Set Selections"), they will override the retained selections when you switch sheets.

Harish_Qlik
Contributor II
Contributor II
Author

Thanks diegozecchini for your help, i created sheet action using variable which storing my previous selections and i selected 'Select values matching search criteria' and i am getting what i want, however the only issue is when i select multiple values (like multiple activitymonths) and move to different sheet the selections removed automatically even after there is no Clear all selections or anything set in Sheet action.

marcus_sommer

I think it means that your approach to store the multiple selection-values is failing and resulting in NULL and then the attempt to apply NULL to a selections removed all selections on it. Therefore take a look on these results - for example by displaying it extra in a text-box and then adjusting the output and if it look ok. you transfers it again to the action.