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 most significant achievement of humanity to date is here. The vizlib table for Qlik Sense! [impressive sounding explosion, applause, gasps].

Officially accredited Extension by Qlik

Vizlib Table
Vizlib Table

Vizlib Table Vizlib Table
Vizlib Table
Vizlib Table

Download Vizlib Table

Up to 5 users free.

Terms & Conditions



Vizlib Table

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. Sparkline 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. Conditional Show/Hide of columns
  7. HTML supports
  8. Freezing Panes
  9. 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 color
  • Cell background color
  • Cell font style
  • Drop shadow
  • Align title left right or center
  • 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 coloring 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 set 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 a 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 a 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.
  • Highlight 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 to pass selections back to the app.

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

  • Column Resizing:
    Enable the users to dynamically resize the columns on the fly.

  • Drag & Drop:
    Permits the user to dynamically the re-order the column orders in the table.

  • 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?:

v2.5.5 12/09/2018

New Features:

  • Added ability to control the border style and color.

Bug Fixes:

  • Hide border on the appearance setting wasn't working.
  • Right click/context menu copy to clipboard wasn't working within the vizlib container
  • The header tooltips were not destroyed after hovering out in some scenarios.
  • Fixed unable to select some particular cells within the table.
  • Sometimes a dialogue was flicking (showing up and immediately hiding) in some version of IE

v2.5.4 15/08/2018

Bug Fixes:

  • Fixed IPad-offline mode rendering issue of onpremise version.

v2.5.3 09/08/2018

Bug Fixes:

  • When a Master Item Vizlib Table created in a previous version of QS June'18 was opened in QSJune18 it showed an "Invalid parameters" popup.



v2.5.2 31/07/2018

Bug Fixes:

  • Fix rendering issues on QS June'18 with virtual proxies.

v2.5.1 25/07/2018

Bug Fixes:

  • When the table was using a MI dimension/measure that does not longer exist (removed), the table was not rendering.
  • Fixed rendering issues with NPrinting, where in small data sets the table was not printing if the extension was already on the NPrinting cache.
  • Improved performance and styling on column the drag and drop.

v2.5 17/07/2018

New Features:

  • Added ability to control what dimensions are selectable or not by the end user.
  • Added option to dynamically position Totals below the last row if no vertical scroll is visible (size to data total position)
  • Added option to control the position of the horizontal scroll bar (size to data/bottom)
  • Improved indicators threshold where now the expression can support a per cell calculations.

Bug fixes:

  • Fixed issues with the latest version of iOS app in offline mode
  • Fixed duplicate rows behaviour in some edge scenarios.

v2.4.6 05/07/2018

Bug fixes:

  • Some dimension&measure styling attributes were not working when converting the table from the native QS table.
  • Fixed compatibility with QS 3.1 suite enterprise.
  • Header arrows were missing after converting the table in June'18
  • Minichart were not rendering on the first load in some scenarios where the table was created with a previous version from v2 of the Vizlib Table.

v2.4.5 03/07/2018

Bug fixes:

  • The column order was not correct when a measure was placed at first.
  • When applying a selection over a mixed (order) table with columns and dimensions, the Qlik Engine was raising an error.
  • Table was shifting columns in some scenarios.



v2.4.4 22/06/2018

Bug fixes:

  • Fixed compatibility with QS June'18.
  • Fixed bug that was affecting mainly April'18 where the dimension search box was not showing up.


v2.4.3 13/06/2018

Bug fixes:

  • Fixed compatibility with NPrinting.


v2.4.2 31/05/2018

Bug fixes:

  • The horizontal scroll bar was not persisting the position after applying a selection in some scenarios.

v2.4.0 22/05/2018

Bug fixes:

  • Fixed issue where Alternate States would not work together with search.


v2.4.0 22/05/2018

Features:
* Ability to control the font size for totals

Bug fixes:

  • Custom Font Family was not working for Headers/Rows
  • Drag & Drop was crashing when a column was hidden
  • Horizontal scroll could not be combined with drag & drop

v2.3.2 10/05/2018

Bug fixes:

  • Fixed issue on IPad where horizontal scrollbar was not working/interactive.

v2.3.1 09/05/2018

Bug fixes:

  • Implemented a fix for rare cases where foreign extensions were causing the Table to create duplicate rows.

v2.3 07/05/2018

New Features:

  • Dynamically re-arrange column order in analysis mode

Bug Fixes:

  • Fixed an issue where sorting would not work using Master Items.
  • Multiselect would not de-select values - this was fixed.
  • Null Cell Background color is now working again.
  • Improved horizontal scroll repositioning after selections.


v2.2 30/04/2018

New Features:

  • Horizontal scroll position is now preserved when selecting values, reordering columns or resizing the column widths.


v2.1 16/04/2018

New Features:

  • Interactive column resizing now available

Bug Fixes:

  • Total row would shrink down in pinned columns in Qlik Sense Desktop
  • Horizontal scrollbars would not appear in Qlik Sense Desktop & iOS App.



v2.0.1 11/04/2018

Bug Fixes:

  • Bulletchart measure type loses its width when show data values option is enabled.
  • Column Pin positioning was not visible in the property panel for old versions of the table.



v2.0.0 09/04/2018

New Features:

  • Separate Dimensions & Measures have been removed - we now only have the concept of columns which can be used interchangeably as measures or dimensions permitting you the rearrange the order of columns as you like.
  • You now have the ability to manually pin dimension/metrics to the right or left in the edit menu.


v1.9.3 06/04/2018

Bug Fixes:

  • Fixed issues with show/hide measure&dimension



v1.9.2 05/04/2018

Bug Fixes:

  • Revert back the ability to add up to 100 dimensions & measures



v1.9.1 03/04/2018

Bug Fixes:

  • When hiding the header row the alignment of inner cells was incorrectly calculated.



v1.9 29/03/2018

Features:

  • New Pinning Feature: Use the ability to either pre-set or interactively pin columns of interest while you are scrolling horizontally to freeze panes. The feature applies both to dimensions, multiple dimensions, as well as to metrics. Dimensions are generally pinned to the left whereas metrics are pinned to the right.
  • New Scroll Bar Design.
  • New Shadow design for vertical scrolling.

Bug Fixes:

  • Compatability improvements with old Qlik Sense versions
  • Fixed issue where scrollbar was overlapping last column values in some versions of Google Chrome.





v1.8.2 13/03/2018

Features:

  • Improvement of the Search Functionality & Feb 18' compatibility

Bug Fixes:

  • Updated Alternate States Manager to support QS Server.





v1.8.1 28/02/2018

Features:

  • Full Cell Text is now displayed on hover
  • You can now specify the name of the exported file
  • Increased number of dimensions to 100

Bug Fixes:

  • Safari & iOS QS App compatibility



v1.8 16/02/2018

Features:

  • Ability to define custom labels for drill-down dimensions
  • Vizlib Table now supports alternate states

Bug Fixes:

  • Fixed sorting & search issues occurring in QS Feb 18'
  • Header Tooltip would persist when the table got removed.



v1.7.3 22/01/2018

Features:

  • Compatability with QS Feb 18'
  • Ability to set a responsive table min-width in case columns are narrow.



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 color 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 virtualization.
  • 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 coloring 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/ center/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 color of Totals, and to set the color 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 color 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 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 & optimizations



v1.0.1 10/04/2017:

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



Coming Soon:

  • Pie Chart and Box Plot MiniCharts
  • Conditional dimensions
  • Favourites

5 Known Limitations
  • If one of the dimensions used in the table is an aggregated dimension, the sparklines will not work properly
  • Vizlib Table is not supported by native printing to PDF/PPT in Qlik Sense
  • 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.
  • Dynamic Resizing & Column reordering in analysis mode is only stored in the session and reset when entered the app. In the future this stored your configuration into favourites will be possible.
  • The Vizlib Table Search functionality has been affected by a bug in the Qlik API introduced with April 2018 (ID QLIK-88628) and is not working as a result.
  • Right-Click Context Menu does not work in Mashups.

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
Privacy Note

2017 © Vizlib Ltd. - All rights reserved.