Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION

Loading Image files stored in database into a Qlik Sense App

cancel
Showing results for 
Search instead for 
Did you mean: 
JonnyPoole
Former Employee
Former Employee

Loading Image files stored in database into a Qlik Sense App

Last Update:

Sep 10, 2019 12:30:55 PM

Updated By:

JonnyPoole

Created date:

Sep 10, 2019 12: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. 

Further more, 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 attached example 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.

 

 

 

Comments
abhijith28
Creator II
Creator II

Hi @JonnyPoole 

I am trying to load .jpg images from oracle sql to Qliksense.

Tried the same technique but i am not able to achieve this scenario.

I am facing error in the load script.

Please help to achieve this scenario.

 

Thanks,

t_donnet
Partner - Creator
Partner - Creator

Hi @abhijith28,

did you found a way to display the image from the oracle db ?

I am facing this problem today.

Regards

Contributors
Version history
Last update:
‎2019-09-10 12:30 PM
Updated by: