topic Re: How to make selection effective On single sheet only in QlikView

How to make selection effective On single sheet only

Wed, 19 Feb 2014 11:10:10 GMT

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.

Re: How to make selection effective On single sheet only

datanibbler — Wed, 19 Feb 2014 11:16:16 GMT

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

Re: How to make selection effective On single sheet only

jonathandienst — Wed, 19 Feb 2014 11:17:29 GMT

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

Re: How to make selection effective On single sheet only

kalyandg — Wed, 19 Feb 2014 11:23:10 GMT

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

Thanks and Best Regards,

Kalyan.D

Re: How to make selection effective On single sheet only

Wed, 19 Feb 2014 11:31:27 GMT

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

Re: How to make selection effective On single sheet only

jerem1234 — Wed, 19 Feb 2014 13:06:54 GMT

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.

Re: How to make selection effective On single sheet only

Andrea_Ghirardello — Wed, 19 Feb 2014 14:31:27 GMT

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

Hope this helps