Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can i make , not having connections between one sheet to another sheet. Here in two sheets i am using same objects and expressions. If i am changing any positions or values of particular object, it should not get effected with another sheet.
Can anyone reply me soon on this.
Thnks
HI
my requiremtn is that while changing among the sheets the the selction should not aplly to other sheets..
Im seeing your qvw file but i m not seeing the bookmark obejct.
Can you tell me how you saved the selections in bookmark?
Linked objects are the sheet objects with same ObjectId.
They are introduced to reduce development time.
When same type of objects across application, share same set of properties (eg. Date selection on all the sheets), it is benificial to link them with each other, so that change at one palce will reflect at rest other palces.
In order to remove liked object, change the ObjectId of the object so that they are no longer linked to any other sheet object.
In addition to bookmark option, you can use Alternate States feature in qlikview.
If you have two sheets in teh appliaction, create two alternate states, apply one alternate state to all the objets of one sheet and other alternate state to all the objects of other sheet.
Bit long procedure, but should work.you have to be careful while using the set analysis when using alternate states.
Regards,
Abhijit
Hi, Thanks for sharing. This works perfectly fine for tabs having independent selections compared to each other.
Is there a way that I can retain the independent tabs as well as I can retain default selections for each tab? Appreciate your response. Regards Akash
Hi Venkat,
Kindly use Detach option by right clicking one of the object
if any change in one object the rest of the objects remains unchanged
Hi Sathish,
Try By using Lock options.It may helps you
Regards
Krishna
Hi Satish,
use below two actions:
OnActivateSheet
The action will be executed each time the sheet is activated.
OnLeaveSheet
The action will be executed each time the sheet is deactivated.
ex: when you want different selections made in sheet1 and sheet2,the selections of sheet1 are still persisting in sheet2,you use action 'clear all' for OnLeaveSheet trigger in sheet 1 and you can use action 'Select in Field' for OnActivateSheet,to select desired values for a particular field in sheet2.
you can learn more about Actions in Add Action dialog in Help file.
Regards
Neetha
Hi Please find the below attachment. It will be clear your doubt.
In the Triggers tab of the Sheet properties, create an Action to Clear All selections on activate of the sheet.
Regards
Krishna