Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Feb 9th, Qlik Product Portfolio Strategy and Roadmap Webinar for Data Integration, last chance to REGISTER

Add external images into a Qlik NPrinting Excel report

cancel
Showing results for 
Search instead for 
Did you mean: 
Ruggero_Piccoli
Support
Support

Add external images into a Qlik NPrinting Excel report

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

Fig 1Fig 1

 

 

Environment:

Qlik NPrinting 

 

  1. Create a folder and insert all flag images into it.
  2. Use the values of the QlikView country field as file names.

    Sonja_Bauernfeind_1-1650368538496.jpeg

  3. Create a text object in the QlikView document you want to use as data source.
  4. Insert the formula ='C:\NPrintingTraining\Pictures\' & GetFieldSelections(Country) & '.bmp' (rather than 'C:\NP_Training\Pictures\' & GetFieldSelections(Country) & '.bmp') as the foreground text.
  5. When a single country will be selected this text field will display the related flag. Save the QlikView document.

    Sonja_Bauernfeind_2-1650368551687.jpeg

     

  6. Create a Qlik NPrinting connection to the QlikView document or refresh the metadata cache if the connection was already present.
  7. Create a new Excel report template as usual.
  8. Add the table with the data as a level and drag and drop it into the template.
  9. Add the new text object into the Images node and drag and drop it into the template.

    Sonja_Bauernfeind_3-1650368571443.jpeg

     

  10. Save the template and run a preview.
Labels (1)
Comments
Daniel_Jenkins
Specialist III
Specialist III

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

HTH - Daniel.

Hatus
Partner - Creator II
Partner - Creator II

Hi @Ruggero_Piccoli @Daniel_Jenkins 

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

 

Kind regards

Hatus

Ruggero_Piccoli
Support
Support

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

poooja
Creator
Creator

Hi Ruggero,

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

Thanks!
pooja

varaprasad0816
Creator II
Creator II

Hi Ruggero,

 

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

Do you have any other solution ?

varaprasad0816
Creator II
Creator II

Adding one more point

Let me know in excel report as well.

haasmwdm
Contributor III
Contributor III

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>

 

haasmwdm_0-1618312635199.png

 

 

 

Version history
Last update:
‎2022-04-19 07:46 AM
Updated by: