Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading Images from SQL server 2008

Hi Guys,

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

  1. 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)
    );
  2. 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;
  3. Load the image to QVW by using an info load

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

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

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

3 Replies
MarcoWedel

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

Regards

Marco

Not applicable
Author

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