topic Re: GET A BLOB INTO YOUR QV SUCCESFULLY! in QlikView

GET A BLOB INTO YOUR QV SUCCESFULLY!

shahamel — Fri, 04 May 2012 10:42:28 GMT

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

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

Wed, 02 Mar 2016 17:10:49 GMT

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.

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

sacosta5 — Wed, 02 Mar 2016 19:13:34 GMT

Hi Femi...

It works for you?.

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

Tue, 15 Mar 2016 18:40:13 GMT

Yes it did

Many thanks again.

Femi

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

Anonymous — Thu, 16 Feb 2017 16:31:35 GMT

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

Re: GET A BLOB INTO YOUR QV SUCCESFULLY!

fabio_vallone — Mon, 05 Jun 2017 13:29:20 GMT

Hi guys

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