Displaying Blob in QlikSense

[dthornburg]

Hi,

I am following the example to display a blob in link below:

https://community.qlik.com/t5/Member-Articles/Loading-Image-files-stored-in-database-into-a-Qlik-Sen...

Load Script is as follows:

LOAD
"doc_facility",
"doc_key",
"doc_seq",
"doc_heat_nbr",
'data:image/PDF:base64,' & "doc" as Document,
len("doc") AS BASE64CharacterCount,
IF(len("doc")=2232,'No Image Available','Image Available') as ImageAvailableFlag,
"doc_name",
"doc_dateTime_added";
SQL SELECT "doc_type",
"doc_facility",
"doc_key",
"doc_seq",
"doc_heat_nbr",
"doc",
"doc_name",
"doc_dateTime_added"
FROM "PER"."PUB"."per_docs";

Data is loading correctly and I am seeing that image is available. Based on script logic. I have defined the map like the example. I am confused how the map knows which field to display. I am not finding in the example where you link the BLOB field to the map. Please help if possible.

Thanks

[daturpin]

Directly above the LOAD statement, is there a table name?

[BLOBS]:  

LOAD....

if you have that, then on the Map, add a point layer, set the "Point" under Data, the location under Location (can be a point field or seperate lat/lon), and under Size & Shape, set shape as "Image from URL" which will allow you to set by expression. In that expression you should be able to use the table and field where the BLOB image is stored, which appears to be the field [Document]

I am not 100% sure that will work...  But give it a try.

I might have to try this. I am using images in a map but I am doing it by loading the images in the "media library" which is cumbersome.

[dthornburg]

Hi,

  Please see attachment. I am getting errors now but confused a to what they are telling me.

Thanks

[daturpin]

The expression for the Image by URL should just be

=[Document]

Don't use the table name unless you have more than one table using the same column, those columns aren't linked, and you implicitly name it so in the load statement.

And you should only be using that as the image source, not a point. The point layer should have one column that is the "name" of the point, and an associated point to go with it. That point is either seperate lat/lon columns in FLOAT datatype, or a point, or line, or multiline, using JSON format:

='[0, 0]'

And I have noticed that in Qlik, you need to use ']]' for every actual ']', so format your points as such, or use a lat/lon pair.

Since you want the lat/lon columns to be linked, try this to generate some INT values for position and see if it works to use those columns as lat and lon:

[per_docs_with_positions]:
LOAD
*,
AutoNumber(doc_key) as latitude,

AutoNumber(doc_seq) as longitude,
RESIDENT [per_docs];

Now use the [doc_name] as data, [latitude] as latitude, [longitude] as longitude, and [Document] as Image by URL

[dthornburg]

Hi,

Tried all these solutions and still not able to get the PDF displayed. Any other suggestions?