Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make selection effective On single sheet only

I want to have different selections to be done in different sheet in same application. So, it means one selection in one sheet shouldn;t be linked with another sheet. Please help . Thanks in advance.

6 Replies
datanibbler
Champion
Champion

Hi Sandeep,

just insert a trigger upon "leave sheet" to take off the selections. (sheet_properties)

=> We have, because those triggers don't quite work in the IE (Ajax client), put it all on the "navigation_buttons" (we have the tabs on the different sheets disabled) - any button, leading to a specific sheet, has several actions

- remove all selections (so that, when pressing the button on any sheet, the selections on that sheet get removed)

- activate worksheet

- make new selections

=> As the buttons are on every worksheet, all as linked_objects, this works in every direction.

HTH

Best regards,

DataNibbler

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

You can define an alternate state on this sheet. Objects on this sheet will make selections in the alternate state and not in the default state. Check out Alternate States on this forum.

Tip: you need to define the alternate state names in Document Properties before you can add alternate states to sheets or objects.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
kalyandg
Partner - Creator III
Partner - Creator III

hi Sandeep Subedi,

You can do it by starting Alternate States,

Go to Document Properties, in tat General Tab, Alternate States button will be available, just click on it, it will ask you to create the name of alternate state, for example you can give the sheet name(Dashboard) itself, so create more alternate states and name according to the sheet name and apply the settings to your qlikview document and save the file.

Later go to the sheet, there go to object properties, in tat General Tab, see in the right side top, there you have options for alternate state, you can select the Dashboard named alt. states for Dashboard Sheet objects and vice verse.

Now selections will effect on only one sheet.

The following images will guide you step by step

Alt State.jpg

DashState.jpg

LBDAltSta.jpg

Thanks and Best Regards,

Kalyan.D

Not applicable
Author

Jonathan, what is with the HTH before your name? I see Data Nibbler uses the same thing

jerem1234
Specialist II
Specialist II

I believe it stands for Hope This Helps, I could be wrong though.

As for separate sheets, I think both ways of adding a trigger on leave sheet or alternate states are good options, depends on how you want it to behave. If you choose alternate states, you can go to another sheet and come back and still have the same selections as you had before. If you use triggers, when you leave it, the selections won't persist unless you add another trigger to remember the selections.

Andrea_Ghirardello

You can use Alternate States or triggers (see my answer here Retaining Selections using bookmark or macro).

Hope this helps