With Vizlib, your tables turn to charts
Tables are boring, sober and uncreative, but at the same time, they are practically honest. Assuming they are correct, numbers can't lie - they are presented as they are and that's why tables will always be needed in a dashboard for data analytics.
Vizlib recognizes this which is why we've built a powerful table extension for Qlik Sense. However, we also believe in the power of visualizations and that is why we have introduced MiniCharts to our Vizlib Table:
- Progress Bars
- Mini-Line Chart
- Mini-Bar Chart
Today we introduce a fourth powerful mini chart type:
A bullet chart is a variation of the progress bar. It serves the purpose of comparing actuals versus targets and displays them in the context of qualitative ranges of performance, such as poor, satisfactory, and good.
Colors in the above image indicate how well each salesman has performed in terms of sales amount. The thin bar will always be your actuals, the red benchmark is the target and the optional areas define the qualitative ranges of sales amounts.
A more detailed blog post will follow soon on how to best use this new type of mini-chart - stay tuned!
Negative Progress Bars
Progress bars have been a popular feature of our Vizlib Table. They visually show the magnitude of a cell-metric compared to other rows. One key element which was missing so far was the support of negative progress bars, for negative values. This is now available as an option
In a corporate world with many different devices, screen sizes and resolutions, object need to be responsive and auto-size automatically. With the Vizlib Table you were so far able to set a fixed column width, but today we also introduce dynamic responsiveness as an option in the table settings.
This feature works best if you have a case where you are using the Vizlib Table in both mobile and desktop apps.
Advanced custom CSS styling (experimental)
We received a lot of requests around very custom formatting options and features. While we could integrate them all, it will most likely bloat the settings panel of the Vizlib Table and make it less easy to use for beginners.
To try to accommodate both worlds, we decided to introduce a new feature which allows the user or developers to specify their very own CSS styling. Be careful - you could break the table with the wrong syntax, and because of that, the feature is unsupported.
If you, for example, would like to highlight a specific cell, you could easily achieve that by writing an expression like the one below:
=if([Sales Rep Name]='John Greg','outline: 2px solid #657dbc')
As a result, John Greg, will see its Sales Amount highlighted with a border, specified using CSS.
https://www.w3schools.com/CSSref/ provides a good overview of all available styling options which could, in theory, be integrated with the Vizlib Table. Happy styling! :)
As always, a new Vizlib release not only comes with big new features, but also plenty of small ones are included as well, not forgetting about constant improvements of bugs. Read the changelog below for full details on what is new in the Vizlib Table v1.6.
Vizlib Table v1.6:
- 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
- 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
If you have any questions or feedback don't hesitate to contact the Vizlib team at email@example.com!