Make your dashboard even more appealing to end user by using country flags.
Please see below how to do that:
1)Download and unzip attached package to your destination folder
2)Open included Excel file and Copy destination path to cell C1.
Formula in Column B will create new path with Flag name
3) Open new Qlikview file and add this code into script window:
LOAD Country,
Flags
FROM
[c:\Users\Robert\Downloads\Flags.xlsx]
(ooxml, embedded labels, table is Sheet2);
change path in red to your destination path:
or you can go to "Tables"
find your file and load data from there.
Please do not load Column C!
Use the "X" at the end of header to hide this column
4) Reload your data.
5) Create Listbox with "Country" as Dimension, go to "Expressions" and add
=(Flags)
Change Representation to Image
Flags should appear at the right of the "Country" name.
Or you can create Textbox
Add =(Flags) as text and from "Representation" choose "Image"
Did You like it?
Feeling Qlikngry?
Comments