How to disregard selection in other sheets ?

[#1]

Hi All,

I have a question here. 

Currently I am using the following expression on set analysis.

AVG(AGGR(AVG({1<EOR_Subject_Name = {'Subject_A'}>* 1<EOR_Program = {'Program_A'}>}Data),EOR_Subject_Name,EOR_Questions))

From what I have learnt online in Qlikview, the 1 should disregard all selection made.  However, when I click dimension in other sheets, they should show changed data which shouldn't be the case. 

Any one can enlighten on this portion ?

Thanks again.

Chun Wey

[er_mohit]

For this particular sheet go to sheet properties

in trigger tab--> add action for both on active and on leave sheet

the action is clear all then ok

and other one is

AVG(AGGR(AVG({1<EOR_Subject_Name *= {'Subject_A'}>* 1<EOR_Program *= {'Program_A'}>}Data),EOR_Subject_Name,EOR_Questions))

hope it helps

[#3]

Hi Mohit,

Thanks for the sheet properties.  It works!  However can the selection remains for other sheets too ?

this is because the selection is clear and other sheets selection are affected.

For the second one, it does not work.

Thanks

[tresesco]

By default the selection is applicable to the entire application. Can you please explain how you want your selections to behave like?

[#5]

Hi,

Example as follow:

The application has 3 sheets; namely sheet A, B, C respectively.

Sheet A has a chart with 2 to 3 dimension selection for user to manipulate the chart in sheet A.

Sheet B has a chart which has no dimension selection.

Sheet C has a chart with 1 dimension selection.

Scenario 1:

When user play with sheet A dimension, Sheet B chart should not be affected in any way.  When user goes to Sheet B and back to Sheet A, Sheet A dimension selection should remains and not be reset to clear all.

Sheet C should be independent and not in any way affected by the dimension selection in Sheet A.

Thanks in advance!

[tresesco · Accepted solution]

If you are using QV11, can try with alternate state. PFA

Else using trigger.

[#7]

Thanks Treseco for the alternate state.  Yes, I am using QV11.  This solve my problem.

Trigger wise, "Clear all" does not resolve. 

[Andrea_Ghirardello]

I think the alternate state is the best way to achieve the result you need.

Otherwise, if you want to use triggers, try the example attached here : http://community.qlik.com/thread/90657

[#9]

Hi Andrea,

Thanks for the link on bookmarks. 

I too agreed that alternate state is the better approach.  Just thirst for more knowledge on Qlikview