Guidance

Vizlib's guidance documentation is your resource guide to making the most of Vizlib products. This documentation focuses on the Vizlib Table, so that the people working with this extension can find useful information to improve performance and succeed with the extension.

This topic contains the following sections:

Best Practice

  • Vizlib Table Setup wizard

    • The wizard is a quick way to setup your Vizlib Table.

  • Vizlib Templates

    • Apply templates to setup the Vizlib Table's style to keep visual consistency across your Qlik Sheets and Applications.

  • Global styling

    • Where possible, if you are displaying large amounts of data, using Global styling over Custom coloring will improve performance because the events aren't being individually calculated.

  • Performance

    • Vizlib Table runs using the Qlik Sense hub engine, and each value is processed separately, which could affect performance if the table has many values. We've listed some recommendations to help you manage this risk and some general advice about improving performance in Qlik Sense here.

      • Calculations add up

        • If you're using calculated dimensions, these will take longer to process than dimensions without calculations.

      • Care with colors

        • Using a highly customized color increases the time and effort the engine needs for processing and can affect performance. Grouping color settings could help you reduce the impact.

      • Size matters

        • Larger tables will take more time to load and complete operations if the engine is processing every event.

      • Mini charts

        • Mini charts are great to use but can easily become overloaded with objects. We recommend using them in tables with fewer than 1000 rows.

  • Wrap up your tooltipIf you're using a tooltip, you can add custom HTML to wrap the text, which is useful for long expressions.

    • Here's a code example:

      <textarea cols="30" rows="2" wrap="hard">This is a sample tooltip to demonstrate text wrapping.&quo

Known Issues

  • Selection (Dimensions)

    • When Enable multi-select or Selections in dimension options are enabled, Vizlib Actions for dimensions are unavailable.

  • Selection (Measures)

    • When Enable multi-select or Allow measure selection options are enabled, Vizlib Actions for measures are unavailable.

  • Mini Chart Set Analysis

    • In version 3.16.0 of Vizlib Table (and above), Minicharts supports expressions with multiple parts and set analysis in all parts of the expression.

  • Dimensions

    • If one of the dimensions used in the table is an aggregated dimension, the sparklines will not work properly.

  • Search

    • Search functionality in Qlik Sense June 2017 release suffers when two different apps are loaded into one mashup. This is not the case with subsequent versions of Qlik Sense.

    • Search functionality has also been affected by a bug in the Qlik API introduced in April 2018 (ID QLIK-88628) and is not working.

  • Horizontal Scroll

    • It repositions to the left (to the start) after any change (for example, after sorting the last column).

  • Fontawesome

    • If you have issues with Qlik Sense November 2019 font awesome icons, you can include the HTML below to resolve any missing font awesome icons.

      <i class="fa fa-users fa-1x" font-family="FontAwesome"></i>

Limitations

  • Context Menu

    • Right-click Context Menu does not work in Mashups.

  • Export

    • When exporting Table data to XLS/CSV etc., the totals won't be included in the exported file. This is a Qlik limitation.

  • Export to CSV

    • If an export to a CSV file returns an error, please duplicate the app, re-publish, and attempt the export again.

  • Resize / Reorder

    • Dynamic Resizing & Column reordering in analysis mode are only stored in the session and reset when entered in the app. In the future, storing your configuration in favorites will be possible.

  • Using Minicharts in the Vizlib Table

    • Requires a dimension column to accompany the measure column (where your Minicharts are). You can create a fake dimension in the data model and then hide it in the Property Panel.

  • Formatted Exports

    • These export types are completed on the client side (on the User's browser). Therefore, this means if you are exporting the Vizlib Table with many formatting options (i.e. text style and cell color) the time it takes to complete is dependent on (Read Bulletpoints Below). This means one user may export 10,000 rows faster than another based on the below information.

      Note: In some extreme cases where the Users computer/browser is not optimal, i.e. runs out of memory, then the User's browser may crash or be unable to download the export.

      • Browser performance

      • Number of Browser Tabs or Computer Applications open

      • PC/Laptop performance and/or remaining resources (i.e. RAM/CPU)

      • Number of formatting options per cell/row/column

  • Export to Excel

    • It is impossible to reflect exactly the same preview of a table in Qlik Sense and Excel, due to different measurements of fonts. By default, our export file is using "Calibri" as a general font and it cannot be changed. Support for user-defined fonts is not possible. In addition there is a different line spacing.

Tech Understanding

  • There currently is no tech understanding.