Tabular reporting with Images in table cells

[joostvanegmond7]

I've created a table in Qlik Cloud with a column representing images from a URL. This works fine. But when I create a tabular report, refering to the created table, the images are not presented in the output of the report. 

Is there are solution for this? 

[David_Friend]

check that your images are following the limitations:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-serv...

I believe the specific image limitations are regarding their size?

Is it possible to share what your output does look like?

[joostvanegmond7]

Thanks David for your quick reply. 

I think I follow the image limitations. In the attachment you'll see the result of the demand report. The table itself had more than 1000 images in it, but I've select 1 article and the link is shown in stead of the image. In Qlik Cloud I can see the image in the table: 

I've tried several image sizes. 

[Lech_Miszkiewicz]

Hi @joostvanegmond7 

You need to realize that what you are doing at the moment is "exporting data" table to excel and that is working as designed. This is the same process as going to Qlik Sense and choosing Download --> Data, which exports data content which is the url link of your image.

The only workaround for this is:

• use of image (instead of table) when designing your report in Tabular reporting tempalte
• use of other means of creating your report (combining levels and for example map objects with image as background) to create what you need. 

The above will greatly depend on your actual report requirements thougg.

cheers

[joostvanegmond7]

Hi Lech, 

Thanks. The workaround does not mee my requirements. I want a multipage report in pdf with on each row an image. It works with going to Qlik Sense choosing Download -> PDF, but then I get just one page. I hoped the PDF output functionality of the tabular reporting does the trick.

I think I should wait for the Pixel Perfect reporting functionality which should be delivered this year. 

Joost 

[Lech_Miszkiewicz]

Hi @joostvanegmond7 

I dont see a reason why pixel perfect reporting would work better than excel tabular reporting. Yes, you will be able to get dynamic image in it, but principles will work the same as in tabular reporting so I dont know as to why that would make a difference?

In fact I am actually in a process of testing pixel perfect reporting for Qlik Sense SaaS and I think there is really no difference in how you would need to go about it (using a level in order to loop through each individual value of the table) - the same as per this instruction from NPrinting Pixel Perfect: https://community.qlik.com/t5/Official-Support-Articles/How-to-add-dynamic-images-in-a-Qlik-NPrintin...

If you do that in excel add-in tabular reporting you could then nest image from map object on each value of the level (note that your table can be added as a level as well as long as it does not contain calcualted dimensions!).

Out of curiosity, When you say it is multi page report - are we talking hundreds or thounds of pages or rather small number <100 pages?

cheers

[joostvanegmond7]

Hi Lech, Thanks four your reply. Maybe I'll do some testing with adding an image on each table row. The multipage reports are just around 10 pages or so. These reports consists just one big table with one each tablerow an image. 

Regards, Joost

[Lech_Miszkiewicz · Accepted solution]

Hi @joostvanegmond7 

I just tested it and as I said earlier - it works.

1. I have created table with all the data I need
2. I have created map object with image as a background
3. I created a report using excel add-in  and used my table as a level and put map object as an image inside that level
4. Run preview and voila

1. Level constructed from my table

2. Data from the level

3. Image from the map object

Preview:

cheers