topic Images: Sql field to Qlik View document in QlikView

Images: Sql field to Qlik View document

Wed, 13 Apr 2011 14:43:24 GMT

Hello!

I have a Sql Data Base and its tables contains a field with images, ¿is it possible to charge the field and display the image to QlikView?

Thank you

Images: Sql field to Qlik View document

Wed, 13 Apr 2011 15:03:51 GMT

I've never done this but I've seen two script statements in the QV reference manual that might help you:

Bundle

Info

I would check out the QV reference manual or search the forums for more details... but hopefully that is a place to start.

Re: Images: Sql field to Qlik View document

Sun, 28 Dec 2014 21:28:29 GMT

Yes, it is possible, using INFO or BUNDLE INFO before the LOAD. I guess in the DB Server the images are stored in blob spaces, if they are too heavy I would not recommend move it to the memory and it really depends on what you are trying to achieve.

If the images are just stored as references to a directory inside the Database Server and the actual images reside in a directory then you can use that reference field to load them via URL link inside the Qviewdocument.

Please, detail a little bit more on what you are trying to achieve.

Re: Images: Sql field to Qlik View document

Sun, 28 Dec 2014 21:31:02 GMT

check this post

http://community.qlik.com/message/686393#686393

the same principle applys the only thing different is that you are making a SQL query . But Qview is able to load a BLOB field also.