Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

Add external images into and Excel report

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
Support
Support

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

HTH - Daniel.

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

Hi @HatusPeters ,

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
Version history
Revision #:
1 of 1
Last update:
‎2017-09-22 09:43 AM
Updated by: