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%
  • Expression

Was this helpful?

  1. Actions

Apply symbol

PreviousActionsNextApply styles

Last updated 4 years ago

Was this helpful?

The action will conditionally apply a symbol (icon) for a cell with a measure and the one of the predefined algorithms: “Positive/Negative” or “Less than 100%”.

Positive/Negative

"Positive/Negative" algorithm can be used to show icons for postive, negative and zero values by setting appropriate icons.

Less than 100%

"Less than 100%" algorithm can be used to show icons for values less than 100% and for values greater or equal to 100% by setting appropriate icons.

Expression

The "Expression" option allows to map the "Symbol" expression's values to particular icons. To be able to use such option a "Symbol" expression should be set for a measure using the properties panel:

After binding the measure with a cell (in our case the "± SALES %" measure) it is possible to map the "Symbol" expression's values to particular icons:

You can add as many mapping items as needed by clicking the button next to the "Edit mappings" label. For each added row you need to specify a value (by entering it in the input text field) and an icon (by selecting it from the icon popup menu).

if("± SALES %" < 0, 'down', 'up')