Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to view a BLOB on Qlikview?

blob.JPG

We have our data in the BLOB.

Currently I am stuck at this point.

Tags (1)
5 Replies
Highlighted
MVP
MVP

Re: How to view a BLOB on Qlikview?

Highlighted
Contributor III
Contributor III

Re: How to view a BLOB on Qlikview?

Thanks for your reply, swuehl.

I looked at the post and learned that Qlikview supports jpg, png, bmp, pdf and rtf formats.

As I still don't see any data for the BLOB field should I assume my BLOB data is not one of the supported formats as mentioned above?

I will find out the my BLOB data format and will check back.

Highlighted
Specialist
Specialist

Re: How to view a BLOB on Qlikview?

Hi,

maybe something like this:

INFO SELECT Imagename,  Image FROM Imagetable;

or

BUNDLE INFO LOAD Imagename, Image ;

SELECT DISTINCT Imagename,Image FROM Imagetable;

Let me know if it works.

Regards,

Highlighted
Contributor III
Contributor III

Re: How to view a BLOB on Qlikview?

Thanks for your reply,

I tried the ones you've mentioned but it didn't work. I still see binary values in the field.

May be the data in BLOB has a different file format. I am checking the same with my DBA.

Highlighted
Contributor III
Contributor III

Re: How to view a BLOB on Qlikview?

Data Blob.JPG

The above is the response for my question to find out the data format of the blob. We know that Qlikview supports only limited formats as I mentioned in my previous replys.

Could someone let me know what would be the best way I can bring this data onto Qlikview may be something like converting to readable format in any other applications?

Based on my requirement I should bring this blob data on to my qlikview applications.