NPrinting Excel 2 tables side by side delete empty rows

LaureDenivelle — Tue, 12 Oct 2021 15:24:04 GMT

Is it possible in Excel NPrinting report to have 2 table side by side and not creating empty lines like this :

NPrinting code :

I use Tables from QlikSense and not Levels.

The problem is the "total" line in fact that multiply all the lines...

regards

Laure

Re: NPrinting Excel 2 tables side by side delete empty rows

Lech_Miszkiewicz — Tue, 12 Oct 2021 21:02:51 GMT

In short: This is working as expected. That is normal NPrinting behvaiour.

So It is not be possible using the approach you are taking. This is because you cannot add row in excel only for columns A:D (which is eaxactly what NPrinting does when populating data). Excel adds rows for all columns which is exactly what we see when we look at your results.

Workarounds:

To get a Total in your tables (if you really insist on having them side by side) I can suggest creating grouping dimension in Qlik Sense data model and use that as a dimension in your table. Whole concept is described here: https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-add-a-second-total-row-in-straight-table/td-p/1229739/page/1 (i describe this in my answer there)
Macro - you can write macro which will either:
- create total in places you need
- or remove empty cells in your second table

thats it.

cheers

topic NPrinting Excel 2 tables side by side delete empty rows in Qlik NPrinting

NPrinting Excel 2 tables side by side delete empty rows

Re: NPrinting Excel 2 tables side by side delete empty rows