Detaching Sheets

[#1]

Hello everyone,

I am currently working on an app to track our 5S method program at work. We preform monthly audits and once the all the items are reviewed; we give each of the 5Ss a grade. The data looks something like this.

Audit Date	Department	Element	Rating	Evaluation
11/12/2013	YYYY	Sort	79%	Acceptable
11/12/2013	XYZ	Sort	85%	Good
11/12/2013	ABC	Sort	90%	Outstanding

I was hoping to be able to set up a sheet with graphs for each department. I am able to set up calculated dimensions for the graphs to filter out the required department and element. However if a department or element is selected on a seperate sheet, the calculated dimensions are overridden.

I was wondering is there a way to detach a sheet to stop this from happening?

[MayilVahanan]

Hi

You can clear all by using trigger function. or if u use qlikview 11 , then you can use alternate state for sheet.

[Josh_Good]

I would recommend using alternate states to do this.  If you put the sheet in a different state then the state will be inherited by all the objects on the sheet.

To setup alternates states dot the following:

Settings -> Document Properties...

On the General tab push the Alternate States button in the middle.

Add a new State

Click OK a bunch of times until you are back on the sheet.

Go to the properties of the sheet and select the Alternate State in the top right of the General tab

[venkatg6759 · Accepted solution]

go to the sheet properties >triggers>on activate sheet>clear all. Thanks

[#5]

Thanks I should have mentioned that I am using a Qlikview 10 so Alternate States is not available. The trigger function was a great alternative though.