How to: Add Country Flags (201 Flags Included)

Created by Robert Mika on Jun 21, 2015 5:52 PM. Last modified by Robert Mika on Sep 8, 2015 11:16 AM.
Version 6

    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

    1.png

     

    2)Open included Excel file and Copy destination path to cell C1.

     

    2.png

     

    3.png

     

    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:

    4.png

     

    or you can go to "Tables"

    5.png

    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

    6.png

     

    4) Reload your data.

     

    5) Create Listbox with "Country" as  Dimension, go to "Expressions" and add

    =(Flags)

    7.png

     

    Change Representation to Image

    22-Jun-15 9-12-03 AM.jpg

     

    Flags should appear at the right of the "Country" name.

     

    Or you can create Textbox

    Add =(Flags) as text and from "Representation" choose "Image"

    8.png

     

    Did You like it?

     

    2015-06-23_070015.png

     

     

    Feeling Qlikngry?

    How To /Missing Manual(18 articles)