I am not able to view blob images in Qlikview

jharke — Mon, 17 Jun 2019 11:47:38 GMT

I am not able to view blob images in Qlikview. I did like described in these threads: https://community.qlik.com/t5/QlikView-App-Development/GET-A-BLOB-INTO-YOUR-QV-SUCCESFULLY/m-p/336229 and https://community.qlik.com/t5/QlikView-App-Development/Display-Image-in-QV-stored-as-binary-data-in-DB/m-p/654457 and others.

There are purchase invoices stored as image in a database. As I go there with a SQL Image Viewer, I see that there is content (see printscreen 1) stored as blob (printscreen 2).

When I make an ODBC connection (not OLEDB), the field 'Document' is recognized as an Info field but no preview is shown.(printscreen 3). Is the problem already here?

Once loaded with this script:

INFO SELECT
YourRef,
Document
FROM "001".dbo.BacoDiscussions WHERE YourRef = '90045613' OR YourRef = '30646905';

I see again the 'i' field

Clicking the ' i ' when selected one, I got this message:

When I insert a text object with '=Info(Field)' and representation = 'Image', I do also not get an image

Alternative way doesn't show any image either:

When I load an image from Excel from my own desktop, it does work:

==> Any ideas where I go wrong trying to get images from a server db?

Re: I am not able to view blob images in Qlikview

jharke — Thu, 20 Jun 2019 11:55:31 GMT

No suggestions / tips / tricks?

Maybe wrong forum?

Re: I am not able to view blob images in Qlikview

Brett_Bleess — Wed, 17 Jul 2019 13:48:02 GMT

Check out the following Help link, hopefully this may help:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Create_Select_Statement.htm

Regards,
Brett

topic I am not able to view blob images in Qlikview in QlikView

I am not able to view blob images in Qlikview

Re: I am not able to view blob images in Qlikview

Re: I am not able to view blob images in Qlikview