topic Re: Loading Images from SQL server 2008 in QlikView

Loading Images from SQL server 2008

Mon, 26 Jan 2015 07:45:58 GMT

Hi Guys,

I'm following these steps in order to load images to Qlikview:.

Create a table to contain the image as a varbinary or image

CREATE TABLE ImageAsVarBinary
(
ID int IDENTITY(1,1),
ImageName varChar(50),
varBinaryData varBinary(MAX)
);
Load an image file to the table

INSERT INTO ImageAsVarBinary (ImageName, varBinaryData)
SELECT 'image1', BulkColumn FROM OPENROWSET (Bulk 'C:\Test.jpg', SINGLE_BLOB) AS varBinaryData;
Load the image to QVW by using an info load

INFO SQL SELECT
ImageName,
varBinaryData
FROM "DB_TABLE_NAME".dbo.ImageAsVarBinary;
Show the image in an object by setting the field value to

=INFO(ImageName)
Set the field/object Representation to Image

But the problem is showing binary data not image as the attached document. Can anyone help me ?

MarcoWedel — Mon, 26 Jan 2015 08:28:54 GMT

Maybe you could temporarily write the images to disk and bundle info load them from there?

Regards

Marco

Mon, 26 Jan 2015 08:39:30 GMT

I use this query:

Info SQL SELECT ImageName,

varBinaryData

FROM TestQlikImage.dbo.ImageAsVarBinary;

but it's not working, it gives me the same result.

Thanks for replaying

MarcoWedel — Mon, 26 Jan 2015 10:43:54 GMT

Maybe this helps:

regards

Marco