topic Re: Clear button clears trigger on sheet in QlikView

Clear button clears trigger on sheet

sr_qlikview — Thu, 28 Mar 2013 15:42:06 GMT

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.

Re: Clear button clears trigger on sheet

kaushiknsolanki — Thu, 28 Mar 2013 17:25:51 GMT

Hi,

Could you please describe what exactly you are doing.

Regards,

Kaushik Solanki

Re: Clear button clears trigger on sheet

sr_qlikview — Thu, 28 Mar 2013 19:03:43 GMT

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.

Re: Clear button clears trigger on sheet

m_woolf — Thu, 28 Mar 2013 19:07:53 GMT

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

Re: Clear button clears trigger on sheet

sr_qlikview — Fri, 29 Mar 2013 13:27:38 GMT

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