OnOffSwitch Extension for QlikView

OnOffSwitch is a QlikView extension which allows you to change the value of a variable with a nice looking interface.

Purpose and Description

• Use this extension to allow users to change the value of a variable with a nice looking interface (very similar to the experience on an iPad).
• You can use this extensions multiple time on each QlikView sheet to manipulate different variables.
• No need to code anything, all properties can be set in the extension's property dialog.
• Settings via extension's property dialog:
  • Name of the variable to be manipulated
  • Label for on/off status

Download & Further Information

• Further information: http://www.qlikblog.at/1851/onoffswitch-qlikview-extension/
• Latest version (.qar file)
• QlikView Demo App using OnOffSwitch

Screenshots

Set your properties using the extension's property dialog:

Use multiple instances of this extension to your QlikView document:

Changes to the status of each extension will automatically change the value of the associated variable:

In a real live scenario, the On/Off switches could be used for:

• enabling/disabling sheets
• enabling/disabling sheet objects
• enabling/disabling dimensions

Instruction - How to use:

Installation & Configuration

• Download the extension
• Install the extension on your local computer (doubleclick on the .qar file)
• Drag'n'Drop the extension within QlikView Desktop (using WebView)
• Set the desired properties:
  • Reference a variable to be changed
  • Set the label properties (by default they will be set to "On" and "Off")
  • Finally deploy the extension to your server (-> detailed instruction)

Behavior of the extension

• If the initial value of an extension cannot be recognized, the default value will be set to the "On" status, but the value of the variable will not be changed until the user first clicks on either "On" or "Off"
• The extension will change the values according to the selected status as follows
  • On = 1
  • Off = 0
• Changing the value for the "On" or "Off" label will not change the resulting variable value

Potential Improvements & Ideas

• Probably I could add more layouts/themes
• Offer more possibilities than just On/Off (like radio buttons), e.g. small, small, regular, large, larger
• Add the possibility to disable the control
• Add the functionality to change target values, so on only 0 for Off and 1 for On, but e.g. 1 for Off and 1000 for Off

Contributing & Issues

Pull requests and stars are always welcome. For bugs and feature requests, please create an issue.

Author

Stefan Walther

• qlikblog.at
• github.com/stefanwalther
• twitter.com/waltherstefan

License

The software is made available "AS IS" without any warranty of any kind under the MIT License (MIT).

See Additional license information for this solution.