topic Re: Inserting country flags in report in QlikView

Inserting country flags in report

Fri, 06 Jul 2012 05:14:44 GMT

Hi All,

I have a straight table which has sales figures for almost 100 countries. I want to insert the image of their national flags in front of the respective countries. Is there any way of doing it?

Thanks

Anirban

Re: Inserting country flags in report

Anonymous — Fri, 06 Jul 2012 05:27:25 GMT

Hi Anirban,

Sure can. You can use Bundle load to include the images in the .qvw file and load them like this for example:

FlagFiles:

bundle info load

CountryCode,

'Images\Flags\Png\'&CountryCode&'.png' as FilenameFlag

resident CountryCodes;

In this example I have a number of png images with the flags named after the country codes, like DE.png for Germany etc.

Then in my straight table I can call the image related to the countrycode using this:

='qmem://CountryCode/' & CountryCode

Re: Inserting country flags in report

Mon, 09 Jul 2012 06:10:56 GMT

Hi Johannes,

Thanks for your reply but unfortunately its not working for me. Let me explain you my condition. I have a folder in which i have all the flags with their country code for eg- Germany - de.png. And i have a separate excel sheet in which i have the country code which is our company specific. For eg - GERMANY , ITALY..all in upper cases.

So how do i go about it, so when i click on the country code specified in my list i can get the respective country flag?

Quick suggestions will be really appreciated.

Thanks

Anirban