On Clear, define default sheet and always select that

[#1]

All,

I have two sheets in my document SH01 and SH02.

When the user hits the clear , If the user is in SH02, I want to trigger an action so that it switches them to SH01.

Reason to look for this solution: SH01 and SH02 works off of two different dates and I have clear state set to select data parameters with date field that is being used in SH01. I have on sheet activate triggers on SH02 which gets overwritten by Clear button.

Any help will be appreciated

Thank you.

Pranita

[#2]

Here is one way you could experiment with.

You can use a field trigger on a field called for instance SwitchMe with data "no" or similar. When you hit clear the field will be cleared so you need to use the onchange trigger and check that the field is cleared, if it is then you activate sheet1 if the user is in sheet2.

Another trigger in sheet 1 and 2 should make a selection in the SwitchMe field "no" so that your onchange trigger will actually trigger again if a clear selection is made.

[disqr_rm]

Try this:

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

[#4]

The example you have refered me to does not  user switch from SH02 to SH01. It does apply the triggers that are related to sheet SH01 but the user still sees SH02.

I am looking for clear all to be treated a hyperlink that will switch me to SH01.

[#5 · Accepted solution]

I haven't read rakesh' suggestion but the attached example works when i tested. At least for selecting sheet 1 on clear. Some adjustments need to be made of course if you have more sheets than 2.

[#6]

Acajohan,

Thank you so much for showing this solution. This is exactly what I am looking for.

Regards,

Pranita