Qlik Community

Ask a Question

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE

Add external images into and Excel report

Ruggero_Piccoli
Employee
Employee

Add external images into and Excel report

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

010.jpg

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

020.jpg

  • 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.

030.jpg

  • 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.

040.jpg

Save the template and run a preview.

Labels (1)
Comments
Daniel_Jenkins
Support
Support

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

HTH - Daniel.

0 Likes
Hatus
Partner
Partner

Hi @Ruggero_Piccoli @Daniel_Jenkins 

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

 

Kind regards

Hatus

0 Likes
Ruggero_Piccoli
Employee
Employee

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

0 Likes
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

0 Likes
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 ?

0 Likes
varaprasad0816
Creator II
Creator II

Adding one more point

Let me know in excel report as well.

0 Likes
haasmwdm
Contributor
Contributor

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

 

 

 

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2017-09-22 09:43 AM
Updated by: