Vizlib Bar Chart

Vizlib Bar Chart is a highly customisable, supported and easy-to-use extension for Qlik Sense which provides features such as grouped bars, stacked bars, and overlapping bars to better compare and visualize quantitive data across a set of dimensions.

Supporting either two dimensions and one metric, or one dimension and multiple metrics, the Vizlib Bar Chart is your go-to extension to create compelling dashboards and charts based on your own data. By controlling the formatting, display, bar type presentation, addition of markers/icons, coloring, dynamic interactivity behavior and the axis, the Vizlib Bar Chart is exceeding by far the standard capabilities of the native Qlik Sense Object.

It allows you to focus on what you are best at: creating compelling visualizations and dashboards without writing a single line of JavaScript code.

Vizlib bar Chart
Vizlib bar Chart
Vizlib bar Chart
Vizlib bar Chart
Vizlib bar Chart
Vizlib bar Chart
Vizlib bar Chart
Vizlib bar Chart
Vizlib Bar Chart
Vizlib bar Chart

Up to 5 users free.

Terms & Conditions

Vizlib bar Chart

Readme

  1. Installation
    1.1 Qlik Sense Server
    1.2 Qlik Sense Desktop
  2. Features
  3. Extension Settings
    3.1 Data
    3.2 Sorting
    3.3 Data Handling
    3.4 Reference Lines
    3.5 Appearance
    3.6 Interactivity
    3.7 Alternate State
  4. What's new?
  5. Known Limitations
  6. Feedback & Bug Reporting
  7. Terms & Conditions


1. Installation

1.1 Qlik Sense Server
  1. Download the .zip file from the link provided your eMail.
  2. Visit the QMC on of your Qlik Sense Server.
  3. Import the .zip file in your extension tab.
  4. Open Qlik Sense and add the 'Vizlib bar Chart' extension to a sheet.

1.2 Qlik Sense Desktop
  1. Download the .zip file from the link provided your eMail.
  2. Extract the .zip file to your default extension folder (documents/qlik/sense/extensions) in Qlik Sense.
  3. Open Qlik Sense and add the 'Vizlib bar Chart' extension to a sheet.

2. Features:

  1. Fully customizable Multi-Bar Chart with rich formatting options.
  2. Choose between Stacked, Grouped and Overlapping Bars
  3. Wide selection of symbols as data point representations.
  4. Ability to add reference lines for both the x and the y-axis or benchmark bars for metrics.
  5. Horizontal and Vertical Display Mode
  6. Support for Alternative Dimensions & Measures
  7. Full interactivity support and ability to turn native functionality off
  8. Option to accumulate metric values over the x-axis.
  9. Support for Alternate States
  10. Up to 5 users free.


3. Extension Settings:


3.1 Data:

The Vizlib BarChart supports either one dimension with multiple metrics or two dimensions with one metric. The data section permits you to add dimensions or metrics dynamically and decide whether they should be used directly or be added as alternative dimensions.

Vizlib Bar Chart


Dimension Settings

Vizlib Filter

  • Calc. Condition
    You have the ability to specify calculation conditions.

Measure Settings

Vizlib Filter

  • Calc. Condition
    You have the ability to specify calculation conditions.
  • Bar Color
    Gives you the ability to specify one color for the measures, overriding any global color settings. You can also specify the bar color using a Qlik expression.
  • Bar Opacity
    Gives you the ability to specify the bar opacity (100% represents full opacity) for the measures bars.
  • Benchmark
    Allow you to create another bar layer behind the existing bars for benchmarking purposes. The benchmark value (which can also be an expression) defines the value and height of the benchmark bars.
  • Data Values
    Show/Hides data values for the particular measures additional settings on the bar chart values can be found under appearance.
  • Accumulate Values
    Provides you with the ability to accumulate values over the dimension. This is particularly valuable when using time dimensions and you wish to see the increments added up to an overall total at the end of the period.

3.2 Sorting:

The Vizlib Bar Chart supports the native Qlik Sense sorting capabilities. More information here on the Qlik Sense Help page:
http://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Visualizations/change-sorting-of-visualization.htm

3.3 Data Handling

The Vizlib Bar Chart supports suppression of zero values and overall calculation conditions.

Vizlib Bar Chart

  • Data downloading
    Gives you the ability to pre-define the amount of data that is downloaded for the particular combination of dimensions and measures. By default, this is limited to the first 5000 rows.
  • Suppress Zero Values
    This setting will suppress rows in the bar chart which are only 0's.
  • Show
    Show/Hide the chart depending on a calculation condition.

3.4 Reference Lines

The Vizlib Bar Chart supports Reference Lines for both the y-Axis and for the x-Axis.

Vizlib Bar Chart

  • Measure/Dimension Value
    Define the Measure or Dimension Value against which the reference line will be plotted in the chart.
  • Label
    Give your reference line a label
  • Font Color
    Choose the font color for your label.
  • Font Size
    Choose the font size for your label.
  • Text Opacity
    Play around with the text opacity of your reference line label
  • Font Style
    Change the style of the label to bold, italic or underline.
  • Label Position
    Define the position of the label, to be either above(left) or below (right) of the reference line.
  • Align
    Define the position of the label, to be either at the start, middle or end of the reference line.
  • Line Color
    Define the color of your reference line.
  • Line Width
    Define the width (thickness) of your reference line.
  • Line Style
    Define the style of your line to be either dashed or normal.
  • Show
    Show/Hide the reference line depending on a calculation condition.

3.5 Appearance


General

Define a title, subtitle & footers for your Vizlib Bar Chart

Vizlib Filter


Presentation

Vizlib Filter

  • Type
    Only displays if you have more than one metric or dimension. Choose from one of three different representation types.
    Vizlib Filter
  • Orientation
    Choose whether you wish to display the Bars vertically or horizontally.
  • Direction
    Set the direction of the y-axis to be displayed either from top to bottom or in reversed order.
  • Bars Formatting
    Ability to set the Width of individual bars as well as the whole grouped bars. You can also define the border rounding corners here.
  • Scroll Preview
    If you have several bars in your chart, the scroll preview permits you so preview the full set of available bars using a scrolling mini chart. You can pre-define the scroll range by determining the number of available bars, as well as define whether the scroll bar begins at the start or the end.

Colors and Legend

Vizlib Bar Chart              Vizlib Bar Chart

  • Colors
    Either use a pre-defined collection of colors, or define your own custom color palette by comma separating a collection of hex color codes.
  • Palette Type
    Choose between gradient and color classes.
  • Reverse Colors
    Reverse the order of colors of the color palette.
  • Persistent Colors
    After selecting a value, colors persist and are not reassigned.

Vizlib Bar Chart

  • Legend
    Show/Hide the legend
  • Legend Position
    Determine the legend position and choose between top/left/bottom/right
  • Legend Font Color
    Define the color of the legend font.
  • Legend Font Size
    Define the size of the legend font.
  • Char Limit
    Apply a character limit to the legend if dimension values exceed a certain lenght.

Grid

Vizlib Bar Chart

  • Grid
    Show/Hide Grid
  • Grid Style
    Choose between line and dashed grid style.
  • Grid Color
    Define the grid color here.
  • Grid Opacity
    Define the grid opacity here.
  • Grid Thickness
    Set width/thickness of the grid lines.

x-Axis Settings

Vizlib Bar Chart

  • Axis
    Show/Hide axis
  • Axis Position
    Position the x-Axis to be either at the top (left) or at the bottom (right).
  • Dimension Labels Position
    Display the x-axis dimension labels either horizontally (lots of space) to vertically (little space) with an angled display in between.
  • Dimension Labels Font Color
    Choose color for x-axis dimension labels
  • Dimension Labels Font Size
    Set the font size of the dimension labels
  • Show Dimension Title
    Hide/Show the x-axis dimension title
  • Dimension Title Color
    Set the Color of the x-axis Dimension Title
  • Dimension Title Font Size
    Set the font-size fo the dimension title
  • Dimension Titel Style
    Choose between displaying the dimension title as bold, italic or underbard.
  • Show alternative count
    Display the number of alternative dimensions.
  • Show drilldown breadcrumbs
    Indicate if the dimension is a drilldown.
  • x-Axis bar Color
    Set the color of the x-axis bar
  • x-Axis Thickness
    Set the thickness of the x-Axis bar.
  • x-Axis Ticks
    Set the number of ticks to be displayed for the x-Axis.

y-Axis Settings

These settings apply both to the left/right axis.

  • Axis
    Show/Hide axis
  • Metric Labels Font Color
    Choose color for x-axis dimension labels
  • Metric Labels Font Size
    Set the font size of the dimension labels
  • Show Metric Title
    Hide/Show the x-axis dimension title
  • Metric Title Color
    Set the Color of the x-axis Dimension Title
  • Metric Title Font Size
    Set the font-size fo the dimension title
  • Metric Titel Style
    Choose between displaying the dimension title as bold, italic or underbard.
  • y-Axis bar Color
    Set the color of the x-axis bar
  • y-Axis thickness
    Set the thickness of the x-axis bar.
  • y-Axis ticks
    Set the number of ticks to be displayed for the x-axis.
  • y-Axis Format
    While the numbers might also come in a specify format, this setting gives you the flexibility to format the y-axis separately from the data points. It uses d3.format() setting options.
  • y-Axis range
    Here you can set the range of the y-axis. You can choose between having it calculated automatically (by taking the qMIn and qMax of the available metrics values) or setting a custom min/max value.
  • min/max smoothing
    This setting ensures that the axis does not begin/end with weird numbers. It smooths the value to ensure the min/max values are rounded to the next “nice” integer.

3.6 Interactivity

Vizlib Bar Chart

  • Allow Selections
    Change the chart into read-only mode if deactivated.
  • Multiselect
    Either make direct selections or enable multiselect mode.
  • Tooltips
    Show/Hides the tooltips
  • Animations
    Enable the user to select multiple rows and accumulate selections until applied.
  • Show maximise Icon
    Enable and disable the ability for users to maximize objects.
  • Show Snapshot Icon
    Enable and disable the ability for users to take snapshots of this pbject.


3.7 Alternate States

Vizlib Bar Chart

Alternate States permit you to assign the Vizlib Bar Chart to an alternate selection state. More about alternate states can be found here: Alternate States Blog

4. What's new?:

v1.3 20/08/2018:

New Features:

  • Big performance improvements on both minicharts and chart rendering (specially visible on IE).

Bug fixes:

  • Disabled selections for null values (was returning a Qlik engine error when selected).
  • Null values in 2nd dimension had a black background instead of stripes (like in 1st dimensions).
  • When the x-axis was disabled the whole chart was not rendering properly.
  • Fixed number formatting.
  • Data values text cuts in some scenarios.
  • Legend tiles labels text cuts in some scenarios.
  • Show all data values was not downloading all Qlik data pages (when bigger than 5k data rows).

v1.2.14 14/08/2018:

Bug Fixes:

  • Selections don't work when calc condition is on 1st position
  • Barchart bars collor was incorrect when the 1st measure was disabled via calc condition
  • Bar chart was disappearing when x axis was hidden
  • Reduced margin on the legend

v1.2.13 10/08/2018:

Bug Fixes:

  • When date values were placed at the bottom it was overlapping with the x-axis.
  • Data handling calc condition message was not supporting expressions
  • Dimension title from a Master Item dimension, was not inheriting the label attribute.
  • When in horizontal mode, 0 values were getting cut-off
  • Outter right reference line labels was overlaping the secondary-y axis.
  • Tooltip tile was not inheriting the color opacity.
  • When using symbols/markers on a measure, the tooltip was appending a text with the measure position: '/#'
  • Data handling > Show all data was not loading all the data pages.
  • Legend labels were getting cut-off.
  • Implemented some performance improvements around the minimaps.

v1.2.12 05/08/2018:

Bug Fixes:

  • Fixed inconsistency on the color tiles of the legend for measures with custom color
  • A tooltip was sometimes being displayed at the top left hand side corner of the screen

v1.2.11 01/08/2018:

Bug Fixes:

  • Alternative measure labels were not resolving expressions within variables.

v1.2.10 27/07/2018:

Bug Fixes:

  • When the bar color in measure was set to custom, the legend tile was not getting updated.
  • When the bar had a null value in Safari the background was white.

v1.2.9 24/07/2018:

Bug Fixes:

  • When the same expression was entered twice with the same label it was not identified as a new expression.
  • Negative stack bars were not rendered properly

v1.2.8 19/07/2018:

Bug Fixes:

  • The Bar Chart was not working when placed on the same sheet as the Vizlib Sankey Chart.
  • Legend tile was not inheriting the bar opacity.
  • Legend align was not working in Qlik Sense Desktop.
  • Tooltip data was showing a different format than the axis in some scenarios.

v1.2.7 05/07/2018:

Bug Fixes:

  • Tooltip was misplaced sometimes when the Bar Chart was embedded into an iFrame.
  • Opacity was not applied to legend tiles for 1dim + n measures.
  • Bars misplacement on secondary axis when the formatting settings was changed.
  • Corrected y/y2 axis label placement wherein sometimes it was overlapping the axis.
  • Improved the smart position of data values (added option to always show data values and not hide them)


v1.2.6 03/07/2018:

Bug Fixes:

  • Dimension label was overlapping the axis sometimes on IE.
  • Wasn't updating some data points after applying a selection on IE.
  • Fixed visualisation issues in stack mode for null values.
  • Data values font size was too small on IE in some scenarios


v1.2.5 27/06/2018:

Bug Fixes:

  • Bar opacity slider was not working.
  • Fixed formatting consistency between data values and tooltips
  • Fixed issue when adding more than one measure in QS 3.2



v1.2.4 07/06/2018:

Bug Fixes:

  • The legend option was not available anymore on the property panel and in newly created bar charts.



v1.2.3 04/06/2018:

Bug Fixes:

  • In some scenarios in combination with other Vizlib Extensions, the tooltip was showing a string HTML color instead of the actual color.
  • Expressions on measures & dimension titles was showing an expression and not the evaluated title.



v1.2.2 29/05/2018:

Bug Fixes:

  • Legend labels were not displayed when using a custom color palette.
  • Enhanced UX on the property panel around Single color mode in the Color & Legend section.



v1.2.1 25/05/2018:

Bug Fixes:

  • Fixed BarChart sorting where in some scenarios were not sorting properly.



v1.2 23/05/2018:

New Features:

  • Secondary Axis is now available.
  • Color dimension values by color palette
  • Sort the Legend Items based on the x-Axis

Bug Fixes:

  • Tick Count was fixed
  • Some Formatting Options were fixed.
  • Stability of data values was improved.



v1.1.3 11/05/2018:

Bug Fixes:

  • IE11 compatibility issue fixed
  • Fixed issue empty values in dimensions would generate unexpected behaviour of the Bar Chart.



v1.1.2 05/05/2018:

Bug Fixes:

  • When data values was enabled, some margin was added in the y-axis showing negative values on the axis despite not having negative values.



v1.1.1 04/05/2018:

Bug Fixes:

  • when data values are vertical are not being shown in edit mode
  • prevent to click/select on null values as engine return error otherwise
  • popup shows HTML text color instead of the actual color in some scenarios

v1.1 22/03/2018:

Bug Fixes:

  • Fixed code collision with Vizlib Filter where the two extensions won't render together.

New Features:

  • Added new reference line label position: Outside
  • Added outline labels in reference lines with rich styling (border thickness, background, color, etc.)



v1.0 14/03/2018:

  • First Release

Coming Soon:

  • Images as reference points
  • Additional formatting option
  • Trend Lines
  • Connected stacks


5 Known Limitations
  • Vizlib Bar Chart does not support native PDF/PPT printing (it does, however, support nPrinting).
6 Feedback and Bug Reporting

Feel free to raise your feedback or bugs found on the page below:
www.vizlib.com/feedback

Contact us:

support@vizlib.com

7. Terms & Conditions

Terms and Conditions
2018 © Vizlib Ltd. - All rights reserved.