Exclude tab irrespective of section

[nareshthavidishetty]

Hi,

How to Exclude tab irrespective of sections in another tab like if the user select year in tab1 and this condition won't effect objects in tab2.

Thanks..

[kaushiknsolanki]

Hi,

You Can use alternate state, if you want all selection to be ignored.

Else you can use Set analysis in expression and exclude the fields which want.

or else you can give clear all action on "on Active" event of a sheet.

Regards,

Kaushik Solanki

[Chanty4u]

qlikview is assosiatie so... u cn use altrnate states may be..

[Mark_Little]

Hi,

As mentioned before you have a few options

Set Analysis - If you wouldn't want to make selections on these tabs, adding the 1 in set analysis

     Sum({1}Sales) for example

Alternate States -  If you need to make selections on these tabs, but not effect the other selections on the other tabs.

Clear selections on activation - This is the quickest answer, but be aware this just clear selections between tabs, so in reality the are effected by the selections, but the user will not see this as moving tabs clears the selections, also when you go back to the original tab there will be no selections

Mark

[pooja_sn]

Goto Settings ->Document Properties -> General -> Alternate States -> Add an alternate state.

Now in Properties of your Sheet1, Set Alternate State to newly added state . Make sure that alternate states of Sheet1 and Sheet2 are different so that any selections on one sheet wont affect another sheet.

[Anonymous]

By using the set analysis to avoid the current selection