Showing icons depending on text values in a dimension

[Anonymous]

Hi Community I need to format a dimension column in a pivot table to show some icons depending which text value the current cell have.

PMP Status
On Track
At risk
Completed
Failed

On Track and Completed => green arrow up

At risk => yellow arrow

Failed => red arrow down

How to do that in QV 11?

Kind regards, Soren

[rwunderlich]

Add an expression that selects the correct image file based on [PMP Status]. An example:

=if([PMP Status] = 'Completed' OR [PMP Status] = 'On Track', 'qmem://<bundled>/BuiltIn/arrow_n_g.png'

,if([PMP Status] = 'At Risk', 'qmem://<bundled>/BuiltIn/arrow_e_y.png'

, 'qmem://<bundled>/BuiltIn/arrow_s_r.png'

))

Then set the Expression Representation Type to "Image".

For the images, it can be easiest to use the bundled image icons (that qmem syntax above) To see what images are available and their filenames; in the Expression Editor select the Images tab, then the Advanced button. Selecting an image and pressing Paste will insert the correct qmem name.

You can also preload your own images using the INFO LOAD script statement.

-Rob