Power KPI
  • PowerKPI for Qlik Sense
  • What's new
  • Compatibility
  • Installation
  • Activation
    • Online activation
    • Offline activation
  • Getting started tutorial
    • Preparation steps
    • Template design
    • Measures binding
    • Formatting
    • Hypercubes
    • Visualizations
    • Actions
    • The final result
  • Video tutorial
  • Features overview
  • Properties
    • HyperCubes
    • Data
    • Sorting
    • Add-ons
    • Appearance
    • Visualizations
    • About
  • Visual editor
    • Cells
    • Data
    • Borders
    • Alignment
    • Font
    • Visual editor keyboard shortcuts
  • Actions
    • Apply symbol
    • Apply styles
    • Set Variable
    • Activate View
    • Go to sheet
    • Next sheet
    • Previous sheet
    • Go to story
    • Go to URL
    • Select values
    • Select all
    • Select match
    • Select alternative
    • Select possible
    • Select excluded
    • Toggle select
    • Clear
    • Clear other
    • Clear all
    • Lock
    • Unlock
    • Lock all
    • Unlock all
    • Create bookmark
    • Apply bookmark
    • Remove bookmark
    • Reload
    • Partial reload
    • Export data
    • Value color
    • Mini chart
    • Zoom in
    • Zoom out
    • Sort
    • Alternative dimensions/measures
    • Searchable dimension
    • Select dimension value
    • Show dialog
    • Show tooltip
    • Show sidebar
    • Show popover
  • Demo Apps
  • FAQ
Powered by GitBook
On this page
  • Positive/Negative
  • Less than 100%
  • Heatmap
  • Text color expression

Was this helpful?

  1. Actions

Value color

PreviousExport dataNextMini chart

Last updated 4 years ago

Was this helpful?

The action will set the font color, background color or border color by using the measure value and the one of the predefined algorithms: “Positive/Negative”, “Less than 100%”, “Heatmap”.

This action can be applied on a cell linked with the dimension or measure

Choose "Font color", "Background color", "Line" or "Symbol" to apply selected algorithm on particular property. Font or background color can be set for particular cell with the help of the action. In case of the "Line" property a border color will be set with the help of the action (if the borders were applied on the cell). The icon color can be set by selecting "Symbol" value.

Positive/Negative

All positive and negative values will be colored in the selected colors.

Less than 100%

The color will be applied on a cell with a measure depending on the measure value: if it is less, greater or equal to 1.

Heatmap

Applies one of the predefined heatmap color schemes.

With the help of “Custom” option you will be able to change "Min", "Average" and/or "Max" parameters and specify colors for minimum, average and maximum values. It allows building custom heatmap color schemes.

Text color expression

This option allows to set a "Font color", "Background color", "Line" or "Symbol" color by using the "Text color expression" for a measure. It has no parameters.

Choose colors for “Positive” and “Negative” parameters by clicking the corresponding button or

Choose colors for “Less than 100%” and “otherwise” parameters by clicking the corresponding button or