Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
Jonathan, what is with the HTH before your name? I see Data Nibbler uses the same thing
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.
You can use Alternate States or triggers (see my answer here Retaining Selections using bookmark or macro).
Hope this helps