RE:All should clear

[Chanty4u]

Hi all,

Sasi K Sasi

I have small issue on my  stright table .

i have  stright table with triggers  and  wen i select the value in  table[Project]  it shud go to next sheet  that is very much fine.

but  wen i came back to the my table sheet the selection should not be there

i.e   it clears all selections?

How to achve?

Thanks in advance.

[settu_periasamy]

Hi,

Do you want Clear All value when you come back in Main Sheet?

May be try with the Trigger OnActivateSheet -> Clear All

[avinashelite]

You could set the trigger on the sheets also , try like this

Go to sheet properties> Tiggers >and set triggers for > select on activate and on  sheet leave

Hope this helps you

[MayilVahanan]

Hi

Try like this

Sheet properties -> Trigger -> OnActivateSheet -> Clear All

PFA

Or, change the trigger based on your requirement. (ie,. Clear only one field, clear all., etc)

[jagan]

HI,

You can clear all the selections you are back to the sheet using the Sheet Level Triggers like below

Try like this

Sheet properties -> Trigger -> OnActivateSheet -> Clear All

Regards,

jagan.

[Chanty4u]

thnks all,

but  i hve  four sheets in my original qvw.

so i want in only one sheet values shud be cleared.?  how it is psbl?

means: i hve seleted in table and cme bak its clear all  no issues.

but wen i made any selection on other sheet and come bak to this sheet  here also no selection availbe?  so how can i achve this?

[Chanty4u]

yeah jagan.  but i need only perticular sheet only ...  but its making clear to all selection in other sheets also.

[MayilVahanan]

Hi,

Could you please say your requirement with example. its little bit confusing..

If you clear one field value in any sheet, its reflect in whole dashboard.

[Chanty4u]

Hi mayil,

Thanks

PFA ..

yeah dat is wat  i dnt want....onle one sheet values shud be clear all?

[jagan]

Filter objects are not restricted to a sheet, it is across a Dashboard level the selections carries across all sheets, if you clear in one sheet it will clear in all sheets.

The workaround for this is create new field from the existing field like below

LOAD

*,

Field1 AS Field2

FROM DataSource;

Now use this field in your sheet and clear it when you are coming to the sheet instead of clearing all the selections.

Regards,

jagan.