Skip to main content

How to read images from a database and display in Qlik Sense and report in NPrinting

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_S
Support
Support

How to read images from a database and display in Qlik Sense and report in NPrinting

Last Update:

Dec 8, 2021 9:17:44 AM

Updated By:

Sonja_Bauernfeind

Created date:

Sep 10, 2019 2:30:55 PM

Attachments

You can load images stored in a database in BLOB format into Qlik Sense by converting to Base64 encoded format in the SQL load script.

You can render the image in the Sense UI using the native Qlik Sense Map object.  This supported object supports expression based sourcing / displaying of the image both as a data field and as a URL to a HTTP accessible image. 

The example attached walks through the setup using the sample AdventureWorksDW SQL database (which contains image files stored as BLOBs) along with both Qlik Sense and NPrinting. 

This technique provides a similar alternative to the BUNDLE load technique which was available in QlikView.


! The information in this article is provided as-is and to be used at own discretion. Ongoing support on the solution is not provided by Qlik Support. Please submit  any questions regarding this solution directly on this community support document
 

Version history
Last update:
‎2021-12-08 09:17 AM
Updated by: