Qlik Entity Image Limitations

[colinodonnel]

Hi all,

Is there a limit on the size of the jpeg produced do you know?

It is being used to put a table into the body of the email.

(the straight table is created in Qlik Sense)

However only the first 15 or so rows are being shown. (Dimensions 1760 x 300, 140 KB).

I have tried rebuilding the table in Qlik Sense and re-creating the Report, but the same result (for PNG too)

Thanks,

Colin

Software Versions used.

Qlik Sense May 2022, Patch 10.

Qlik NPrinting May 2021 SR3, Version: 21.14.7.0

[Lech_Miszkiewicz]

Hi @colinodonnel 

There are few basic things you need to fix before moving forward? I am providing links to version of NPrinting you have mentioned (although those are already archived)

1. Your combination of NPrinting and Qlik Sense is not supported: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/System-requirem...
2. You are also running unsupported version of NPrinting which needs to be upgraded
3. Images are printed same as you see them in hub as documented: 
   1. https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Qlik-objects-supp... 
      1. as documented: Only the visible part of a visualization will be exported. For example, you export a Qlik Sense table that has scroll bars as an image. You will see the scroll bars and the window area that they specify, but not the entire table. To see how an object will appear in a report, open a Qlik Sense browser window on the Qlik NPrinting Engine machine. Next, apply the same size and resolution used in the report template.

Now regarding actual solution I think you can have possibly 2:

1. you can try adjust the size of the actual object as mentioned in help
2. or build it properly as html table. That would be my approach as only then you can guarantee that everything will be visible. 
   1. https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/HTMLReports/HTML-Reports-Contain.htm...
   2. make sure you test styles used inline for support against email clients you will be using. Email clients dont support many CSS styles and you may get different results when previewing table in Outlook on Windows vs Outlook on Mac vs Gmail vs other mail clients like mobile or Thunderbird etc..

If you fancy building more advanced table/pivot table you can check this out: https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting . Word of advice would be though to first understand and learn how regular tables work in HTML before doing anything else with it.  

cheers

[colinodonnel]

Hello there,

Thank you for your detailed response.

Since then, our nPrinting has been updated to May 2022 SR3.

The Qlik Entity Image is still not rendering fully. It replicates the table in the Qlik Sense app, showing the table headers and the table total, but it does not show all the rows in the middle, so it is incomplete.

I have tried the HTML solution, it looks fine, however it does not seem to show the table totals! Is it possible to code in a table total?

It seems then that the last remaining option is via data modelling and to build a "total" row into the data as suggested in a previous post of yours:

detailed concept of subtotals in straight tables is described here by @Vegar  (Thanks Vegar):

http://www.aqlik.se/2019/01/sub-totals-in-a-qlik-straight-table/

Before I go ahead with the data modelling solution, is there any simpler method?

Thank you

[Lech_Miszkiewicz · Accepted solution]

Hi @colinodonnel 

Of course there is simpler solution. 

The grouping dimensions suggested by @Vegar  is usually my preference as it does not require additional work on NPrinting side https://community.qlik.com/t5/Qlik-NPrinting/Want-to-calculate-column-total-in-Nprinting-HTML-report.... I also like it because if have many expressions then you dont need to replicate them but...

Since total is just one extra line you can use NPrinting formulas in order to put them at the bottom of your table: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Formulas.htm

You would need to create as many totals formulas as many expressions you have in your table (1 formula for each measure)

cheers

[colinodonnel]

Hi Lech,

Thanks for your assistance. It has been very helpful.

I will go with the data model solution and create a total / subtotal as a dimension, and use sorting to ensure the total / subtotal appears in the correct row as required.  For clarity this is based on the solution provided here:

http://www.aqlik.se/2019/01/sub-totals-in-a-qlik-straight-table/

The solution suggested in your second paragraph is great, however I have lots of measures and is inefficient to implement .

Cheers,

Colin