Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Chanty4u
Esteemed Contributor III

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
MVP & Luminary
MVP & Luminary

Re: RE:All should clear

PFA.

Regards,

jagan.

18 Replies

Re: RE:All should clear

Hi,

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

May be try with the Trigger Capture.JPGOnActivateSheet -> Clear All

Re: RE:All should clear

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

Re: RE:All should clear

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)

MVP & Luminary
MVP & Luminary

Re: RE:All should clear

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
Esteemed Contributor III

Re: RE:All should clear

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
Esteemed Contributor III

Re: RE:All should clear

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

Re: RE:All should clear

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
Esteemed Contributor III

Re: RE:All should clear

Hi mayil,

Thanks

PFA ..

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

MVP & Luminary
MVP & Luminary

Re: RE:All should clear

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.