Formatting and appearance
Covers styling the grid as a whole, individual columns, and totals.
Grid-wide styling
Section titled “Grid-wide styling”Under Settings → Styling:
- Header - Font Size, Font Color, Header Background Color, Header Height (32-200, or auto).
- Content - Font Size, Font Color.
- Row Hover - turn hover highlighting on or off, and set its color and font color.
Per-column styling
Section titled “Per-column styling”Each custom column has its own Column Styling settings in the property panel:
- Background color / text color - a plain color picker, since custom columns aren’t evaluated by the Qlik engine the way dimensions and measures are.
- Header background color / header text color.
- Number format or Date format - a pattern with a live preview as you type. Date columns also offer 7 built-in presets alongside the custom pattern option.
- Text alignment and column width (Auto, Fit, Pixels, or Percentage).
Regular Qlik dimensions and measures are styled the normal Qlik way instead - with a color
expression (for example =IF([Variance] < 0, RGB(200,0,0), RGB(0,128,0))), since those
columns are driven by the engine.
Totals
Section titled “Totals”Under Settings → Totals, choose Auto or Custom, a Position (None, Top, or Bottom), and a Totals label (default “Totals”). Separately, any Number custom column can turn on Show column total to have RLV Scribe sum that column’s values into the totals row.
Formatting precedence
Section titled “Formatting precedence”When more than one styling rule could apply to the same cell, RLV Scribe applies them in this order, each overriding the one before it: theme defaults → the grid-wide Styling panel → that column’s own styling → the cell’s current selection state → hover.
Worked example
Section titled “Worked example”A cost-tracking sheet colors its Variance measure red when negative and green when positive using a Qlik color expression, gives its Actual Cost custom Number column a light-blue header background via Column Styling so it visually stands out as an input column, and turns on Show column total on both Actual Cost and Variance, with Totals → Position set to Bottom.