On_Click action on

[#1]

Hi everybody!

I have beautiful bar-chart and i have table which shows me positions that make up each bar. 

When i click on bar - table appears, and when i click on specific button("hide table") it disappears.

I have filter("current selections") on my WorkSheet and when i click on one bar , selection is applied to all sheet (maybe i'm mistaken, correct me?).  then i click  "hide table" and current selections  is cleared. 

One problem i have. In this worksheet you can choose some predefined selections that will appear in "current selection", and when i choose on of these predefined selections , then  click on bar, then click on "hide table", all my selections are cleared (all is correct, but not convenient for my clients).

Can somebody suggest me clear solution how i should fix this problem, or what should i do? I thought about 2 "Current Selections" in one WorkSheet. One "currnet selections" is main, one - hidden and will be duplicated.

[its_anandrjs]

In this is suggest 2 options 1st lock the fields before hiding the table 2nd is yes you can use 2 current selection objects.

Hope this helps

[#3]

i'm trying to implement first and second solutions that you suggest, but there is no result (

maybe there is possible save current selection state and restore it after closing table?

[#4]

Hi,

Use Bookmarks

For this create 1 bookmark by default with name BM1

For example,

at the time of table hide action, use replace bookmark(BM1)

and at the time of displaying table,use apply bookmark(BM1)

[#5 · Accepted solution]

I Fix this issue using this answer Clear the field

Clear only one field from Current Selection