Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Showing icons depending on text values in a dimension

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



1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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