Break a link between searches and sheets

[paul_ripley]

Hello

I have replicated on QV a report that the Finance used to do on Excel.  The report had a number of worksheets.  In QV I was wondering if it is possible to have sheets in the report that do not update when you make selections in other sheets.  ie the sheet is independent and only updates based on the selections you make on that particular sheet

Many thanks

Paul

[Gysbert_Wassenaar]

Yes, you can create alternate states on the General tab of the Document Properties window. After creating an alternate state you can assign it to a sheet on the General tab of the properties window of the sheet. By default objects on a sheet will inherit the state from the sheet they're placed on. Objects in an alternate state will ignore selections in the default state and will reflect only selections in their alternate state.

[krishna_2644]

See attached.

[paul_ripley]

Thanks both for your help

I have tried to follow the example .qvw , and have created 2 sheets that are not linked by using 'alternate states'.  However, one of the sheets  doesn't now react to any filters I make on that that sheet.  Can you suggest what I have done wrong?  I am new to this community and I don't know how to attach my .qvw file to show you

[avinashelite]

I think you have copied the filter from sheet 1 to sheet 2 may be that's the issue. Please recreate the objects and check whether you have applied the alternate states on the sheet level or object level 

[paul_ripley]

Thanks.  I think it must be something to do with the formula in my expression, the alternate state seems to work on some sheets but not others

Thanks for your help

[Gysbert_Wassenaar · Accepted solution]

That's possible.

1. Inherit the state from the sheet: sum({<MyDim={'A'}>}Value)
2. Use the default state: sum({$<MyDim={'A'}>}Value)
3. Explicitly use an alternate state (or bookmark): sum({AltState1<MyDim={'A'}>}Value)

If you use the $ in your set analysis expressions then you select from the default state. If you assign an alternate state to a sheet and the sheet objects inherit from the sheet then you should be careful about using the $. You may not get the result you intended.

[paul_ripley]

Thanks Gysbert.  That was the problem.  I'm pretty new to QlikView so big thanks to everyone for helping me out!