Clear button clears trigger on sheet

[sr_qlikview]

I have a trigger on my sheet (ex: OnActivateSheet  - isTestFlag =1 )

When i hit on clear button it clear the trigger. I try adding  action on clear button properties as clear other fields - isTestFlag, it gets and 1 and 0 values for this field.

How to handle this, is there any expression in the button action to control this ?

Thank you.

[kaushiknsolanki]

Hi,

     Could you please describe what exactly you are doing.

Regards,

Kaushik Solanki

[sr_qlikview]

I have field like 'isTestFlag' in my Data model which set that flag = 1 on a condition like region ='US' .

we get all the data to the application but on a selected sheet we want to get only the US data with out using filters, which i have done using the onactivatesheet trigger when isTestFlag = 1.

but when i click on clear button (which has action - clear other fields , field = currency ) it wipesout the trigger filter and gets all the data.

[m_woolf]

http://community.qlik.com/message/201654#201654

[sr_qlikview]

i added the same inselectfield action on the button. that worked.