Horizontal selection bar with initial selection capabilities. Selections through both click and swipes. The Selection bar also handle setting variables and showing flags that can be used for selections. Typical use case is as a top bar with Year, Month, Country selections and variable settings for currencies and budget/forcast alternatives. See more in this video: https://youtu.be/4fxrphADRKw
Tested from Qlik Sense June 2017 (in the initial release of June 2017, extensions load slow. It's fixed in patch 1 )
The selection bar that also serves as a "trigger" for initial selections. For feature list see screenshots below.
Works only with Qlik Sense 3.0 and up!!
- Field - Standard horizontal selection from any field in the application. Intended for use with Year/Month field but will of course work with any field.
- Variable - For variable selection of single ("always one selected") variable. Typical use is for currency selection.
- Flags - Easy country selection where you don't have room for a map but want something that looks nice.
- Initial selection - Any field/variable can be set for an initial selection using an expression or comma separated list.
- Date range picker (Experimental!) - Drop down calendar for selection of dates
- Download the latest version of Qlik Sense (3.0 or higher)
- Qlik Sense Desktop
- To install, copy all files in the .zip file to folder "C:\Users[%Username%]\Documents\Qlik\Sense\Extensions\cl-horizontalselectionbar"
- Qlik Sense Server
- See instructions how to import an extension on Qlik Sense Server
- Select the typ of list you need (Field,Variable,Flag or Date Range Picker)
- Enter a reference to:
- Field - Any field or an expression that works as a dimension
- Variable - Has to be an existing variable created either in the script or the gui. Selectable variables are entered in a comma separated list.
- Flag - Select a field that has a country name corresponding with the flag names. (Has to be a perfect match with the flag name so check the list of flags if you are not sure.)
- Date Range Picker - A field holding a date field with a "complete" set of dates. (i.e. no gaps in the timeline) It uses the DateFormat variable for the date format, both to parse the dates and when selections are made. If the Today expression is left blank it default to Now().
- Add a field label
- Add an initial selection if you want. This will also work with expressions such as "=Year(Today())-1".
- You can set initial selections to be updated once per session or every time you move to a sheet.
- Left - All lists aligned to the left
- Right - All lists aligned to the right (Sometimes works well with two selection bars combined on the top row. One right-aligned and one left-aligned)
- Center - All lists as closed to the center as possible. (Leaves sides empty if space is available.)
- Center Spread - All lists centered but with outermost lists pushed towards the edges. (Works well when you want to use the full screen width for one selection bar object with multiple lists.)
- Stack - All lists on top of eachother. (Works when using more than one grid height of the selection bar. Also good for smaller screens.)
- Set up this in your load script:
//Application ID (insert your app ID)
LET vL.ApplicationName= 'app/7bd83989-1767-4311-9948-aade7a8b3a1c/';
//Sheet ID (insert your sheet ID)
LET vL.Sheet = 'sheet/5e07ada0-03aa-4708-8c12-4e03f68bce75/state/analysis'; //Selections
SET vL.Options = '/options/clearselections/select/' & GetCurrentSelections(']/select/','/[','];[') & ']'; //Final URL
SET vL.URL_DocumentChaining = vL.ApplicationName & vL.Sheet & $(vL.Options);
- Use this variable in the link setting of the extension
$(vL.URL_DocumentChaining)
Like this extension? Check out the other Climber made extensions below.
Custom Report
KPI
Cards
Contributing to this project is welcome. The process to do so is outlined below:
- Create a fork of the project
- Work on whatever bug or feature you wish
- Create a pull request (PR)
I cannot guarantee that I will merge all PRs.
Initial selections will not work on calculated dimensions/autogenerated date fields.
Karl Fredberg Sjöstrand @ Climber
See CHANGELOG
See LICENSE