Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?

Tags (2)
2 Replies
Highlighted
Creator
Creator

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

No suggestions / tips / tricks?

Maybe wrong forum?

Highlighted
Digital Support
Digital Support

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

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.