topic Resetting Variable state on Clear Button. in QlikView

Resetting Variable state on Clear Button.

Anonymous — Fri, 09 Sep 2011 19:10:23 GMT

Hi,

How to reset the variable state after pressing the clear button.

Here i am providing the details of my issue.

List Box :

2011-Q1

2011-Q2

2011-Q3

2011-Q4

2010-Q4

2010-Q3

Variables:

Whenever I opened the qlikview application, listbox default select to current Quarter(20011-Q3), and variables set to following values.

ThisQuarter - 2011-Q3

LastQuarter-2011-Q2

When you select any other value in listbox automatically variables will reset .

Eg: if you select 2010-Q4 in list box

variable values set like this

ThisQuarter - 2010-Q4

LastQuarter-2010-Q3

Then if i click on Clear button ,it sholud go to initial state.

I can able to select the Value in Listbox (i.e 2011-Q3), But variables values are still showing latest values.(

ThisQuarter - 2010-Q4

LastQuarter-2010-Q3).

Can you please help me how to resetting the variable values on clear state?

Regards

Katla

Resetting Variable state on Clear Button.

Anonymous — Fri, 16 Sep 2011 13:23:53 GMT

You can do this by creating your own button, which clears the selection and set your variables to what ever value you want.

Create new button object.

Add >> Selection : Clear All

Add >> External : Set Variable

That should work imo.

Good luck,

Dennis.

Resetting Variable state on Clear Button.

Sat, 17 Sep 2011 11:10:41 GMT

Creating your own button is OK but then the user can still use the standard clear.

The best solution is creating a dummy field in the script (just use an 'Inline' with 1 row) which is not displayed anywhere (so it can never be selected). Attach a macro to the OnSelect trigger for the dummy field and within it set the values of the variables as required. When the standard 'Clear' button is clicked this will fire the trigger.

Regards,

Gordon

Resetting Variable state on Clear Button.

Mon, 26 Dec 2011 17:33:56 GMT

Hi Gordon,

I tried it, but it is not working. Click on "Clear" does not triggers Fields OnSelect + macro.

Any idea how to solve it?

Thanks in advance,

Aldo.

Re: Resetting Variable state on Clear Button.

Fri, 30 Dec 2011 10:39:35 GMT

Aldo,

Iit needs to be set on the field (not the sheet object) through document properties>triggers>field event triggers.

Demo document attached.

Regards,

Gordon

Re: Resetting Variable state on Clear Button.

Sat, 31 Dec 2011 10:19:26 GMT

Hi Gordon,

I did the almost the same as you. Yours work, mine not.

I will check the differences.

Thanks in advance,

Aldo.

Re: Resetting Variable state on Clear Button.

Wed, 04 Jan 2012 11:45:54 GMT

Hi Aldo,

See this updated version - I have removed the macro attached to the trigger and replaced it with an update to a variable that is set to the current time and displayed in the listbox.

This works fine (as does the macro) in v9sr4 and worked ok in previous versions too.

Regards,

Gordon

Re: Resetting Variable state on Clear Button.

ljjtimmermans — Wed, 04 May 2016 07:08:44 GMT

Worked for me. Thanks