NPrinting Excel 2 tables side by side delete empty rows

[LaureDenivelle]

Hi

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

[Lech_Miszkiewicz]

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... (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

L