Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

shahamel
Contributor

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
Tags (3)
5 Replies
Not applicable

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

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
New Contributor III

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

Hi Femi...

It works for you?.

Not applicable

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

Yes it did

Many thanks again.

Femi

joantbak
New Contributor III

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

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

fabio_vallone
Contributor

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

Hi guys

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