topic On off Button in QlikView

On off Button

Fri, 06 Feb 2015 16:44:32 GMT

I have a 'last 12 months' button.

Action : Select in Field

Field: =VDateField

Search String: =v12 months

While this works there is no way to toggle it off. What action would I need to add in order to be able to turn this button off ?

Thanks

Peter_Cammaert — Fri, 06 Feb 2015 16:48:44 GMT

You mean to disable the button? Or do you mean to undo the selection.

The first can be done using Properties->General->Enable Condition.

The second one using the clear field icon in the title bar of the listbox.

Peter

Peter_Cammaert — Fri, 06 Feb 2015 16:50:12 GMT

Or for the second type of "turn this button off", create another button (call it undo) with an Action called "Clear Field".

Fri, 06 Feb 2015 18:18:14 GMT

if you need to toggle to the string, I usually use if statement, some version of (you may need to tweak to get the variable to reference correctly):

if($(VDateField)='v12 months','','v12 months')