The use of icons and other visual cues has been proved as a great value asset in data visualization.
Icons let people to better understand complex information. Another good thing about icons is that they let us communicate globally. An up-pointing triangle is universally understood as a representation of growth.
QlikView brings you the possibility to choose from a predesigned set of visual indicators.
A good alternative to the standard icons is the Unicode Geometric Shapes set.
“Unicode is a computing industry standard for the consistent encoding, representation and handling of text expressed in most of the world's writing systems.” (Source Wikipedia).
Geometric Shapes is a set of visual indicators that effectively work as a text character. This means, you could use it everywhere you can write text in QlikView. Text objects, captions, cells, sheet titles, etc.
The main advantage of using Unicode Geometric shapes over images is the fact that you can control their properties, like size and color as any other text character. You could, for example, set up an expression to change the color based on an expression.
Another good example of how to take advantage of Unicode Shapes is including them as a part of number format pattern. You can predetermine how the shape will look for positive and negative values.
▲ #,##0.0%; ▼ #,##0.0%
Using this pattern will let you integrate an icon inside a cell like as in Change column in the table below.
Color is, in some situations, not enough to differentiate from one state to another. Using different fills or patterns will help color blind people to identify differences.
To include any of these shapes into your next QlikView project you just need to copy the shape from here and paste it where needed.
You can also go to your Start Button on windows and search for Character Map, this will give you lots of options including Geometric shapes and other handy symbols and icons that can add value to your Apps
You can select the font, it must me a font used in Qlikview!, you can double click the icon you want and click copy, then simply paste it into your Qlikview document
Quite handy indeed - I hadn't realized we could put the trend arrows into the number format.
As always, I will reiterate the following note about color: there is no need to use a color for a "regular" positive result. Use color only when attention is required - either because something is wrong (red, orange, yellow), or something is going unusually well and thus requires attention (blue is preferred, as green/red is a problem for the color blind, but green is acceptable - use a different fill as stated above, and ideally different saturation). If everything is on target and this particular object does not require the user's attention, there's no reason to use a color at all.
Mr. Arturo, I want to know if you have the video of the session today, Tips & Tricks – Geometric Shapes: Replacing images with Unicode Characters- Global People Enablement Program. Thanks.