Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying images from database field (Access OLE objects)

I am trying to display images (I tried PNG first then BMP) dynamically from a database table.

Imagine I have this "Country" table with the following fields :

- Name_Country // The textual name
- ImgFlag_Country // An image of the flag

- Population_Country // A number representing the population

When I try to display ImgFlag_Country in a textbox (with the representation setting set to : Image)

nothing appears at all, even when i select a country which HAS an image in the database

What did I do wrong?

I am using MS Access, and the image field is an OLE Object field
I looked at this thread : http://community.qlik.com/message/130715#130715

I tried many different things in the script, including this : (but I never got it to work)

Country:
INFO LOAD `Name_Country`,
`ImgFlag_Country`,
`Population_Country`;
SQL SELECT *
FROM Country;


Please note that I am using QV Personal Edition, I cannot open qvw files or I will loose my license on my current dashboard

0 Replies