Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)
Now regarding actual solution I think you can have possibly 2:
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
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
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
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