Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
qbi_soren
New Contributor II

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
MVP & Luminary
MVP & Luminary

Re: Showing icons depending on text values in a dimension

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