Solved: Formatting the dimension values - Qlik Community

tommyl · ‎2020-08-04

Hello,

I have a dimension created with inline load in the script editor named: 'Criteria'. It has values like: 'NET', 'GROSS', 'OPENING', 'CLOSING'.

I want the 'CLOSING' label to be displayed bold in a pivot table:

Criteria	2019-Q1	2019-Q2	2019-Q3
OPENING	18721
GROSS	253523
NET
CLOSING

Can anyone help me on doing this?

haskia · ‎2020-08-04

In the Qlik Sense standard Pivot Table it is not possible to change the font layout, as far as I know.
Some extensions (like Vizlib) offer more customization options.

However, as a workaround, Totals columns are always bold - so you could try this feature. You can then adjust the field values in the totals row with Dimensionality() as described here:

Hope this helps.

Best regards

View solution in original post

haskia · ‎2020-08-04

In the Qlik Sense standard Pivot Table it is not possible to change the font layout, as far as I know.
Some extensions (like Vizlib) offer more customization options.

However, as a workaround, Totals columns are always bold - so you could try this feature. You can then adjust the field values in the totals row with Dimensionality() as described here:

Hope this helps.

Best regards

tommyl · ‎2020-08-06

Thank you for the answer.

Best regards,

T.