Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted
Esteemed Contributor

Re: How to make selection effective On single sheet only

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

Highlighted
MVP
MVP

Re: How to make selection effective On single sheet only

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
Highlighted
Partner
Partner

Re: How to make selection effective On single sheet only

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

Highlighted
Not applicable

Re: How to make selection effective On single sheet only

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

Highlighted
Valued Contributor II

Re: How to make selection effective On single sheet only

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.

Highlighted

Re: How to make selection effective On single sheet only

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

Hope this helps