Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jharke
Creator
Creator

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
Creator
Author

No suggestions / tips / tricks?

Maybe wrong forum?

Brett_Bleess
Support (Former)
Support (Former)

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.