How to disable the triggers in navigating one sheet to another sheet in QVW

[Anonymous]

Hi team,

please look on attached QVW file.

in that i made some current selection issues.

I made 3 seriousness in all seriousness i want to work same behavior

for example

in my dashboard i created two triggers.when i was opened first time that triggers will work Expectantly

but after open QVW file while i am navigating to one sheet to another sheet i want to disable the triggers.

for ex:in my QVW file i have sheet1 and 2

in that sheet 1  i made current selection ...when i was opened first time triggers will fire ..after that i made some chages in sheet 1 like i removed all the filters so now in current selection we hdont have any filters

now i navigate to sheet to sheet and again i wil come sheet2 to sheet 1 then that time i dont want to see ant filters in current selection

because after opening the qvw file i removed all filters na i need same as it is

for more please look QVw file

Please think advance ..for ex in current selection i have 20 fields.i dont want to make hard code ..so everything i need dynamic

[santiago_respane · Accepted solution]

Hi,

that happens because you have triggers at document and at sheet level.

If you want to fire a trigger at document opening but when moving between sheets you want to keep your made selections you need to delete your triggers at sheet level.

So it will keep the triggers on document opening.

Please let me know if this helps.

Kind regards,

[satishkurra]

Hi

PFA the screen shot where there are triggers in SHeet level, Please add to document properties triggers or remove in sheet level based on your requirement...