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

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 color
  • Cell background color
  • 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 mini chart 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 data set 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
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.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 dialog 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 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:

  • Lazy load scrolling so you don't have to paginate unless you want to!
  • More options for conditional formatting
  • Conditional dimensions

5 Known Limitations
  • If one of the dimensions used in the table is an aggregated dimensions, the sparklines will not work properly

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.