Vizlib Table

Vizlib Table is a highly customisable, supported and easy-to-use extension for Qlik Sense which provides features such as horizontal scrolling, dynamic labels, mini charts and sparklines, font and size control, interactivity, colours, guidelines and more, far exceeding the standard capabilities of the native Qlik Sense Object

First, there was the light bulb, then man landed on the moon, and now.. the greatest achievement of humanity to date is here. The vizlib table for Qlik Sense! [impressive sounding explosion, applause, gasps].

Vizlib Table
Vizlib Table

Vizlib Table Vizlib Table
Vizlib Table
Vizlib Table

Download Vizlib Table

Up to 5 users free.

Terms & Conditions


Readme

  1. Installation
    1.1 Qlik Sense Server
    1.2 Qlik Sense Desktop
  2. Features
  3. Extension Settings
    3.1 Dimensions
    3.2 Measures
    3.3 Sorting
    3.4 Add-ons
    3.5 Appearance
    3.6 Interactivity
  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 Table' 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 Table' extension to a sheet.

2. Features:

  1. Horizontal scroll of columns
  2. Full color and alignment control
  3. Spark line charts / mini charts on each line
  4. Full interactivity support and ability to turn native functionality off
  5. Header formatting and dynamic label support
  6. Up to 5 users free.

3. Extension Settings:


3.1 Dimensions:

The Vizlib Table supports unlimited dimensions.

  • Dynamic Title - Assign a dynamic title to the column.
  • Assign an icon to that will appear next to the dimension title - over 600 icons to chose from.
  • Cell text colour
  • Cell background colour
  • Cell font style
  • Drop shadow
  • Align title left right or centre
  • Right column border


3.2 Measures:

The Vizlib table supports unlimited measures. The styling options available include:

  • Cell text color
  • Cell background color
  • Cell font style
  • Drop shadow
  • Align title left right or centre
  • Right column border
  • Measure Representation - This can be text, progress bar or a mini chart.
Progress bar

Progress bar is a bar representation of the measure, you can set the color either using the color picker or by expression.
You can also toggle show value to show the figure inside the bar.

Minichart

The MiniChart allows you to add a small line or bar chart into each row of the table based on the dimensions. This works by selecting the mini chart dimension.

Additional sparkline settings include:

  1. Use same smart date
  2. Stretch over time - to keep gaps in dataset displayed.
  3. Mini chart type, either bar or line.
  4. Bar or line color (either color picker or fixable with expression).
  5. Negative bar color (either color picker or fixable with expression).
  6. Bar spacing slider (in pixels)
  7. Zero Axis


    Interval Coloring for Data Points (line only)

The interval colouring requires you to enter a JSON string which defines the interval and the color code how the data points should be colored.

Example:

='[{"from": -1000, "to": 0, "color": "#ff0000"}, {"from": 0, "to": 1000000, "color": "#00ff00"}]'

If data points fall outside of a defined interval, they will not be plotted.
You can define as many intervals as you like. A more user-friendly component/interface to define them will be introduced in due course.


3.3 Sorting:

The Vizlib Table 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.4 Add-ons

The Vizlib table supports show zero values and a calculation condition.


3.5 Appearance

Header settings
  • Show or hide the header row.
  • Change the header font size of the table in Qlik Sense. (Slider or by expression).
  • Change the font family
  • Change the font style - bold, italic, underline.
  • Drop shadow on text
  • Change background color by colour picker or by expression.
Row Settings
  • Change the row font size of the table in Qlik Sense. (Slider or by expression).
  • Change the font family
  • Change the font style - bold, italic, underline.
  • Drop shadow on text
  • Change background color by colour picker or by expression.
  • Row border hide or show toggle.
Table Settings
  • Alter show more data button text.
  • Change initial data pagination size.
  • Change null cell background color by picker or expression.
  • Change the null symbol.
  • Highlight rows on hover toggle.
  • Highligh style settings, background color, font color.
3.6 Interactivity

Interactivity enables the users to interact with the data in the chart as well as navigate throughout the scatter view for a better view of the chart.

  • Allow Selections:
    Gives the user the ability to select the bubbles in the chart in order to pass selections back to the app.

  • Enable Multiselect:
    Enable the user to select multiple rows and accumulate selections until applied.

  • Enable Interactive Sorting:
    Change table sorting when click on the header cell.

  • 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.


4. What's new?:



v1.7.2 15/01/2018

Features:

  • Vizlib Table now supports up to 100 measures (before we had a limit of 50).
  • Ability to change the background and text colour of individual headers, supported both for dimensions and measures
  • Ability to add a custom tooltip when hovering over the header. Particularly useful if you want to add some explanation or additional information on the metric/dimension. Supports HTML.
  • Improved performance of very wide Vizlib Tables using horizontal virtualisation.
  • Vertical Scroll is now always visible, even with horizontal scroll.

    Bug Fixes:

  • Improved the drag selection of multiple dimension values.

  • Bug fixed when using the Vizlib Table as a Master Key Item in Story mode
  • Wrapping of Header Cells has been fixed.
  • Sorting Arrows was sometimes misaligned.
  • Fixed data values in Bullet Chart to be inline with the cell
  • CSS styling issues with the header and body size.



v1.7.1 28/12/2017

Features:

  • Ability to set the row height by either specifying it or by letting it calculate automatically.

    Bug Fixes:

  • Removed unintentional top & bottom padding within cells.


v1.7 22/12/2017

Features:

  • Significant performance improvements
  • Data Points on Mini Line Chart are now supported including custom colouring based on intervals.
  • Load more data button has been replaced with a more user-friendly endless scrolling functionality.

Bug Fixes:

  • Right-padding in cells would sometimes disappear in mashups. This has been rectified.



v1.6 01/12/2017

Bug Fixes:

  • Fixed some compatibility issues with IE11



v1.6.1 17/12/2017

New Features:

  • Number formatting of mini-chart tooltip now inherits the measure format.
  • New calculation methods for column totals: Avg, Count, Min, Max, Sum
  • New Relative split options: Convert column metric values relative % to total.
  • New Advanced Custom CSS Styling options for cell formatting (experimental).
  • Progress Bars are now also supporting negative bars as an option
  • New Mini-Chart type: Bullet Chart
  • Auto-Fill option now distributes the available width evenly between available columns. This is useful to make the Vizlib Table responsive to different screen resolutions.
  • Compatability with QS November 2017

Bug Fixes:

  • Font Colors of Total row was not working and has been fixed
  • Conditional expressions in the column width would not work. This has been fixed



v1.5.3 16/11/2017

New Features:

  • Ability to position the "Show more Data" button on the left/ centre/right.

Bug Fixes:

  • When loading two apps into a mashup, the Vizlib Table Search functionality would conflict. This is still occurring in Qlik Sense June 2017 Initial Release due to a reported API bug.



v1.5.2 02/11/2017

  • Enhanced HTML compatibility with custom HTML directives and attributes to facilitate 3rd party components integration inside the table.



v1.5.1 18/10/2017

  • Fix introduced for WebSocket communication error when extension is embedded in mashups sitting outside of Qlik Sense hostname.



v1.5 06/09/2017:

New Features:

  • Search functionality has been added
  • Indicators can now be driven by a dynamic expression
  • Ability to format the font colour of Totals, and to set the colour of cell borders.

Bug Fixes:

  • Totals, when positioned at the bottom, would sometimes misalign - this has been fixed.



v1.4.2 10/08/2017:

Bug Fixes:

  • Fixed an issue where promises would not work in IE11 when the extension was used on a mash-up sitting outside of Qlik Sense.
  • Exporting on a virtual proxy is fixed
  • Sometime Export dialogue would not appear, after second use.



v1.4.1 06/08/2017:

Bug Fixes:

  • Show all data sometimes freezing browser
  • Show/Hide measure misplaced column
  • Table would not re-render on removal and re-addition of a new dimension
  • CSS clashes with Leonardo UI



v1.4 31/07/2017:

New Features:

  • Updated .qvf Demo example app shipped with the extension.
  • In-cell HTML support - customize your expressions or metrics using HTML tags.
  • HTML tag support for Headers
  • New measure representation: Indicators
  • New cosmetic feature: fill the last column with the rest of the table width.

Bug Fixes:

  • Fixed misalignment of "Load more data" button
  • Fixed breaking of columns when pagination was active
  • Performance enhancements for Sparklines
  • Show all data feature has been recovered



v1.3.3 19/06/2017:

  • Fixed Bug where setting the color of the progress bar would sometimes freeze the property panel



v1.3.2 15/06/2017:

  • New Feature: Conditional Color Formatting of the progress bars
  • Bugfix for Exporting Table Data to XLS
  • Support of the Vizlib Table for Master Key Items
  • Support of the Vizlib Table in Story Mode
  • Bugfix for incorrect conditional background colour in rows



v1.3.1 21/05/2017:

  • Full Support for Internet Explorer 11 & FireFox
  • Added a new Vizlib Table Demo app (.qvf) with lots of examples.
  • Fixed Bug where the color of row highlighting would conflict if there were more than two tables on the sheet.
  • Dynamic Labels are now maintained in the XLS/CSV Export.



v1.3 23/04/2017:

New Features:

  • New .qvf Demo example shipped with the extension.
  • Added Export to XLS/CSV/TSV on right-click
  • Adjustable Column Widths
  • Support for QS v3.2.3

Bug Fixes:

  • Bar Chart is overlaying remaining columns
  • Column is lost when a measure is being hidden*
  • Show total does not work by default.
  • Support for QS v3.2.3
  • Converting to Vizlib Table was losing default values



v1.2 18/04/2017:

  • Copy Cell content on right-click
  • Measure can now be displayed as an URL
  • Drag selecting multiple cells
  • Support for Internet Explorer
  • Several Bug fixes & optimisations



v1.0.1 10/04/2017:

  • Initial extension release
  • Dynamic Labels
  • Sparklines
  • Conditional Show/Hide of Measures
  • Rich formatting options



Coming Soon:

  • Horizontal Virtualisation
  • Pie Chart and Box Plot MiniCharts
  • Conditional dimensions

5 Known Limitations
  • If one of the dimensions used in the table is an aggregated dimensions, the sparklines will not work properly
  • Vizlib Table Search functionality in Qlik Sense June 2017 release, suffers in a scenario when two different apps are loaded into one mashup. This is not the case with subsequent versions of Qlik Sense.

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
2017 © Vizlib Ltd. - All rights reserved.