topic Re: Break a link between searches and sheets in QlikView

Break a link between searches and sheets

paul_ripley — Thu, 16 Jul 2015 15:37:26 GMT

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

Re: Break a link between searches and sheets

Gysbert_Wassenaar — Thu, 16 Jul 2015 18:19:21 GMT

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.

Re: Break a link between searches and sheets

Qrishna — Thu, 16 Jul 2015 18:27:44 GMT

See attached.

Re: Break a link between searches and sheets

paul_ripley — Fri, 17 Jul 2015 11:54:49 GMT

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

Re: Break a link between searches and sheets

avinashelite — Fri, 17 Jul 2015 11:58:16 GMT

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

Re: Break a link between searches and sheets

paul_ripley — Fri, 17 Jul 2015 12:41:39 GMT

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

Re: Break a link between searches and sheets

Gysbert_Wassenaar — Fri, 17 Jul 2015 12:46:43 GMT

That's possible.

Inherit the state from the sheet: sum({<MyDim={'A'}>}Value)
Use the default state: sum({$<MyDim={'A'}>}Value)
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.

Re: Break a link between searches and sheets

paul_ripley — Fri, 17 Jul 2015 12:57:00 GMT

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