Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Employee
Employee

With the June 2020 release of Qlik Sense came many chart enhancements.  My favorite is the addition of mini charts to a table. In a table, a measure can be visualized via a mini chart as either bars, dots, sparklines, or positive/negative.

table.png

This enhancement not only makes a table more appealing to look at, but it can easily point out changes and trends in the data. To add a mini chart to a table, follow these simple steps:

  1. Add a measure to the table. In the example above, Sum(Sales) is the measure.
  2. In the Properties window of the table, change Representation to Mini chart.
  3. Select the dimension to indicate what data to view. In the table above, Month was the selected dimension.
  4. Select the Type of mini chart to add (bars, dots, sparklines or positive/negative).

That is it, the mini chart is added to the table. There are other options that can be adjusted to change the look and feel of the mini chart. In the Colors area, there is the option to select the color of the bar/dot/line as well as the option to select the color of the max value, min value, first value and last value. If showing a sparkline mini chart, you also have the option to show dots on the line for each data point of the selected dimension. The y-axis can also be adjusted for the mini chart. There is the option to use local or global so you can decide if the y-axis range is based on the specific row or all rows. There is also the choice to select auto, zero as baseline or zero as center for the y-axis. Read more about mini chart in Qlik Help.

Mini charts are eye candy for your table. Dress up the measures in your table with mini charts to provide another layer of information in an easy to digest manner. Learn more about the Qlik Sense June 2020 release by checking the links below:

 

Thanks,

Jennell

1 Comment
Partner
Partner

Great news Jennell,

This is one of the QlikView features that I've been waiting on for several years. It's an important feature that is very hard to replicate in other ways. I'm surprised you consider it to be eye candy.

Thanks for the update,

Barnaby.

296 Views