Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted

Re: Loading Images from SQL server 2008

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

Regards

Marco

Highlighted
Not applicable

Re: Loading Images from SQL server 2008

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

Highlighted

Re: Loading Images from SQL server 2008