Different "Current Selection" in different sheets

[stekol61]

Hi!

I'm loading different data into two different tables.

Data from table 1 is presented in Sheet1 and data for table 2 in Sheet2.

Below you can see that the "Current Selection" is the same inboth Sheet 1 and 2.

The Dimention "HostName" is only valid for Sheet1 and not for Sheet 2.

How can I hide "HostName" in "Current Selection" in Sheet 2?

Sheet 1:

Sheet 2:

[sunny_talwar]

May be use alternate states for each sheet or use trigger to clear selection in HostName when you eneter Sheet 2 using On Activate Sheet trigger under sheet properties

[stekol61]

If possible i would like to keep the selection in Sheet1 when I enter Sheet2.

How to use alternate states?

[sunny_talwar]

Check out these links

Examples of Alternate States in Chart Expressions ‒ QlikView

Alternate States ‒ QlikView

http://www.qlikfix.com/2014/08/12/alternate-states/

[Miguel_Angel_Baeyens]

I created this example long ago to show how to keep selections for sheets specifically (sheet 1 with its own selections, sheet2 with different ones, etc.). Maybe this can help you in creating your own solution

[stekol61]

This works fine in the QlikView application.

However it doesn't seem to work when I publish it to AccessPoint.

I can see the Bookmarks in AccessPoint but they are not updated. Seems to have the same selections as was used when the report was published.

[stekol61]

This works fine in the QlikView application.

However it doesn't seem to work when I publish it to AccessPoint.

I can see the Bookmarks in AccessPoint but they are not updated. Seems to have the same selections as was used when the report was published.