topic Re: Detaching Sheets in QlikView

Detaching Sheets

Thu, 26 Sep 2013 18:21:27 GMT

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?

Re: Detaching Sheets

MayilVahanan — Thu, 26 Sep 2013 18:31:01 GMT

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

Re: Detaching Sheets

Josh_Good — Thu, 26 Sep 2013 18:32:07 GMT

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

Re: Detaching Sheets

venkatg6759 — Thu, 26 Sep 2013 18:43:17 GMT

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

Re: Detaching Sheets

Thu, 26 Sep 2013 19:43:30 GMT

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.