Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:All should clear

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.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

PFA.

Regards,

jagan.

View solution in original post

18 Replies
settu_periasamy
Master III
Master III

Hi,

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

May be try with the Trigger Capture.JPGOnActivateSheet -> 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)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
jagan
Luminary Alumni
Luminary Alumni

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
MVP
MVP
Author

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
MVP
MVP
Author

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.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Chanty4u
MVP
MVP
Author

Hi mayil,

Thanks

PFA ..

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

jagan
Luminary Alumni
Luminary Alumni

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.