Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
jharke
Creator II
Creator II

I am not able to view blob images in Qlikview

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/33622...and https://community.qlik.com/t5/QlikView-App-Development/Display-Image-in-QV-stored-as-binary-data-in-... 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).

1.png

 

2.png

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?  

3.png

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

4.png

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

5.png

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

6.png

 

7.png

Alternative way doesn't show any image either:

8.png

 

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

9.png

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

2 Replies
jharke
Creator II
Creator II
Author

No suggestions / tips / tricks?

Maybe wrong forum?

Brett_Bleess
Former Employee
Former Employee

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...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.