Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sheets

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

26 Replies
Not applicable
Author

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?

AbhijitBansode
Specialist
Specialist

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

ankurakash
Contributor III
Contributor III

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

Not applicable
Author

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

krishna20
Specialist II
Specialist II

Hi Sathish,

Try By using Lock options.It may helps you

Regards

Krishna

Anonymous
Not applicable
Author

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

krishna20
Specialist II
Specialist II

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