How to add Flag images in Powerpoint.

[poooja]

Hi Qlikies,

I wanted to bring the flags based on the country selection into Nprinting power point report.

My .PNG files are in the share point folders. I am trying to bring the flags into Qliksense App (or)  Nprinting power point template.

I'm using Qliksense version Nov 2018 and Nprinting April 2019 version.

Thanks!
Pooja

[Lech_Miszkiewicz]

1. I would load dynamic images to Qlik Sense first. You can folow methodology from the link to create images in Qlik Sense which will change depending on your selections:

https://community.qlik.com/t5/Qlik-NPrinting-Documents/Loading-Image-files-stored-in-database-into-a...

Note that you may want to adjust script little bit as you will not load your images from DB and you just want to point it to your QS library.

2. the second option which I prefer is to actually convert images to base64 codes and load them as a data and then follow the steps from the link.

regards

Lech

[poooja]

Hi Lech,

 Thanks for the solution. I might need extra guidance here as i have  no authorize to load the images into DB. All my .Png files are in the Folder or in the https://. How to load these images?

Thanks in Advance.

Regards!

Pooja

[Lech_Miszkiewicz]

If you cannot use DB, just use excel table or text file (I am attaching a sample with text file and qlik sense sample app in zip file).

Create an excel table/text file with 2 columns:

1 - column with country name (or country ID), so you can link it to the rest of your Qlik Sense data model

2 - column which will hold base64 code for an image.

You need to convert all you images to base64 codes, for this you can use some of those online tools: https://www.base64-image.de/

Once you convert them to base64 and load them to Qlik Sense app you can follow instructions from my previous link.

Note that image will be shown only when you select one image(in your case 1 country)

Other things to consider:

• you may want to spent more time setting up map object and
  • disable zooming
  • set only 1 zoom level so the map does not scale/crop image
  • show and hide zooming options
  • make sure all images have the same resolution and are as small as possible/required (bigger images will take more time to render!!!)

you can also read about base64 images here (different approach where I used image as formula in NPrinting) 

https://nprintingadventures.wordpress.com/2019/05/24/creating-email-content-in-nprinting/