Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shahamel
Creator
Creator

GET A BLOB INTO YOUR QV SUCCESFULLY!

Dear users,

For those who are having problems with a blob in your database. This is my solution.
I have a SQL Database with a table which contains an employee id and a picture. This picture has the datatype image. An image is another datatype. For example you have, integer, string, etc. Image is also a datatype.
What is did is; i made connection with my database
ODBC
CONNECT32 TO [SUDBPROD SQL2008];

Then i wrote this statement. You can change the database name and the fields to make it work for yourself.
INFO SELECT EMPLID, "EMPLOYEE_PHOTO" FROM "Synaxion LVS".dbo."SDC_PSCS_EMPL_PHOTO";

Blobs

The

Blobs page makes it possible to bundle so-called Blobs, Binary

Large Objects, in a QlikView document. It is usually a picture, a

text file or similar, stored as a single entity in a database management

system. The icon indicates that the field contains a blob.

The blobs in the database are listed together with size, in KB, and

type in the

Blob Viewer . The Blob is previewed next to the list if it

is an image. QlikView supports jpg, png, bmp, pdf and rtf blobs.

Bundle

The

Bundle button opens the Bundle Dialog where the

Key Field for the Blob data

is selected and the blob can be

resized to fit in the table cell if it is an image. Mark

Shrink

246

Images

and apply width and height to resize the images to

fit. The setting does not handle aspect ratio.

I hope this is useful for this community.
Gr. Sandeep
5 Replies
Not applicable

Many thanks Sandeep for this code snippet. I ve been researching for over 10mths on how to accomplish this.

You made my day

Thanks again!

Regards

Femi.

sacosta5
Contributor III
Contributor III

Hi Femi...

It works for you?.

Not applicable

Yes it did

Many thanks again.

Femi

joantbak
Contributor III
Contributor III

Many thanks Sandeep Hamelink Like others this helped very much in solving the mystery of getting database stored images in to Qlikview.

fabio_vallone
Creator
Creator

Hi guys

Also it's possible simply to insert TO_CHAR(<blob variable>) then you fix the #Error0 message from Qlikview.