article Add external images into a Qlik NPrinting Excel report in Official Support Articles

Add external images into a Qlik NPrinting Excel report

Ruggero_Piccoli — Tue, 19 Apr 2022 11:46:23 GMT

Goal: Insert country flags into an Excel report. This solution works also with HTML reports, not only with Office reports. See Fig 1.

Fig 1

Environment:

Create a folder and insert all flag images into it.
Use the values of the QlikView country field as file names.
Create a text object in the QlikView document you want to use as data source.
Insert the formula ='C:\NPrintingTraining\Pictures\' & GetFieldSelections(Country) & '.bmp' (rather than 'C:\NP_Training\Pictures\' & GetFieldSelections(Country) & '.bmp') as the foreground text.
When a single country will be selected this text field will display the related flag. Save the QlikView document.
Create a Qlik NPrinting connection to the QlikView document or refresh the metadata cache if the connection was already present.
Create a new Excel report template as usual.
Add the table with the data as a level and drag and drop it into the template.
Add the new text object into the Images node and drag and drop it into the template.
Save the template and run a preview.

Re: Add external images into and Excel report

Daniel_Jenkins — Tue, 24 Oct 2017 21:52:01 GMT

For a working sample project see: Re: Flags in Nprinting table objects

HTH - Daniel.

Re: Add external images into and Excel report

Hatus — Thu, 07 Mar 2019 09:50:11 GMT

Hi @Ruggero_Piccoli @Daniel_Jenkins

Is there a way to do the same in Qlik Sense without extensions?

Kind regards

Hatus

Re: Add external images into and Excel report

Ruggero_Piccoli — Mon, 11 Mar 2019 13:31:57 GMT

Hi @Hatus ,

I did some tests with Qlik Sense without extension but I was not able to find a solution.

I did not tested, but maybe it is possible to create a workaround by using Excel macros (supported in recent versions). Macros are not runned by Qlik NPrinting but you can trigger them on Excel report opening.

Best Regards,

Ruggero

Re: Add external images into and Excel report

poooja — Sat, 19 Oct 2019 17:48:34 GMT

Hi Ruggero,

Thanks for the detailed explanation. let me know if its possible doing this in Qliksense /Nprinting power point Template.

Thanks!
pooja

Re: Add external images into and Excel report

varaprasad0816 — Fri, 25 Oct 2019 11:43:36 GMT

Hi Ruggero,

I have tried in pixel perfect as per above mentioned steps but not getting images dynamically.

Do you have any other solution ?

Re: Add external images into and Excel report

varaprasad0816 — Fri, 25 Oct 2019 11:44:10 GMT

Adding one more point

Let me know in excel report as well.

Re: Add external images into and Excel report

haasmwdm — Tue, 13 Apr 2021 11:17:36 GMT

Hey guys, I don't know if there is another post on this topic. But if you want to display images in an HTML report as described above and embed it in an e-mail, the following works for me:
Perform the same steps as above only in the HTML report template.

<html>
<body>
<th>image</th>
<th>system number</th>
<th>property number</th>
<th>designation</th>
<th>quantity</th>
<th>QS text</th>
</tr>
%%CH01_level%%
<tr>
<td> <img src="%%TX01%%" alt="TX01"></td>
<td>%%System number_1%%</td>
<td>%%System number_1%%</td>
<td>%%Designation_1%%</td>
<td>%%VOPMENGE_1%%</td>
<td>%%QS Text_1%%</td>
</tr>
%%/CH01_level%%
</table>

</body>
</html>