topic On Clear, define default sheet and always select that in QlikView

On Clear, define default sheet and always select that

Thu, 19 Jan 2012 21:46:48 GMT

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

On Clear, define default sheet and always select that

Fri, 20 Jan 2012 00:01:14 GMT

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.

On Clear, define default sheet and always select that

disqr_rm — Fri, 20 Jan 2012 00:39:44 GMT

Try this:

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

On Clear, define default sheet and always select that

Fri, 20 Jan 2012 22:45:24 GMT

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.

Re: On Clear, define default sheet and always select that

Sat, 21 Jan 2012 10:24:00 GMT

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.

On Clear, define default sheet and always select that

Sun, 22 Jan 2012 15:52:58 GMT

Acajohan,

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

Regards,

Pranita