2 Table overlapping side by side in Qlik Reporting (Excel Add-In)

[prads_uk_2025]

I am trying to achieve
Table 1    Table 2
Table 3

But, in Qlik Reporting Excel Add-In
Table 1 has 6 rows incl total
Table 2 has 12 rows incl total
so the Table 1 is growing with Table 2. Unable to design it properly. Deleting the contents for data privacy.

Qlik Dashboard is also similar which is coming perfectly fine but not the report.
I tried pixel perfecting as well. No luck.

[Frank_S]

@prads_uk_2025 

• Try deselecting the 'expand range' option as described here: Formatting properties for tabular data | Qlik Cloud Help
• or consider creating a table that contains all the fields you wish to report on and use the new table in your report
• and or consider creating a sheet in your app that contains the table data you need, then export the entire sheet as an image.

Kind regards...

[Lech_Miszkiewicz · Accepted solution]

Agree with @Frank_S 

Disable expand range, but study also the consequences of disabling it for those tables which you dont want to expand. 

Cheers

[prads_uk_2025]

Thank you Frank for hinting the option however, the Table fails to get me the Total at the bottom. I am not using Table option or Format table option (where u can Switch ON the Total Sum under Table design ) as the User want plain white background with no lines.
Also, I feel it is happening as I am trying to fit many tables into one page.
Earlier, they have done it in Power BI report builder and its coming way too acurate. I have tried with Pixel Perfect reporting too but since the formulas are little complex, its not worth it.

[prads_uk_2025]

Thank you Lech. The option is making Total Row invisible. I tried adding it by adding an Expression directly but still no visible. Might be due to space constraint.

[Lech_Miszkiewicz]

Hi @prads_uk_2025 

To have totals at the bottom you can either:

• use table option and just create your own colour scheme for it as you are not limited to pre-defined colours and templates
• or if your table has always the same number of rows create a total line in required cell overarching all cells which will be populated by data from Qlik. Note that as opposed to "expand range" enabled you need to place total in the cell where you expect it to be taking into account all rows which will be populated by data from Qlik.

I really dont see a problem here. It is rather simple configuration in excel template. 

Using pixel perfect in this very example is not really suitable as it will have its own challenges and having it side by side may not be possible

cheers

[prads_uk_2025]

Yes, Lech. I did the permutations and combinations and now it is coming correct. Thank you.
I think it is stressful for 1st time.
Also, was adding the time and date and page number.
The sample generated PDF has
Timestamp of email generated (bottom left) align exactly with Report Name (Extreme Left top)  and Page number (bottom right) with Logo (extreme right top).
No direct option on online Excel 365 for header and footer so I edited in the desktop version and checking the preview option. Its not synch in with it.
Any clue of how to add -- Time stamp of email generated??
And Page number?

[Lech_Miszkiewicz]

Any reason why you are not using excel desktop client to do development end-to-end? I know web version is very limited and then syncing not always work. 

I would use add-in on desktop version of excel and do whole development with it. 

cheers 

[prads_uk_2025]

We have Qlik Sense Saas / Cloud in here and our Qlik support team asked us to use Excel online version. Somehow, the add - ins option is not available in Excel desktop that is why.

[prads_uk_2025]

@Lech_Miszkiewicz @Frank_S ..
Also, Are you aware on how to remove nwanted entries in the PDF output?
I have 2 levels:
Asset Type: Long Book
Category: Equity, NA, PIK Note
as can see from the screenshot below:
I am keeping it dynamic, Equity and NA have no values so, #REF is coming whereas, it should not be in PDF at all. How can I omit it? 
Is there any way we can control this behavior.
Excel Template:

table 

<Type for HYSL Report_2_Level>
<Type for HYSL Report_2>
<Category for HYSL Report_3_Level>
<Category for HYSL Report_3>
Issuer	Asset	Country	Moodys Rating	Maturity	Coupon Spread	Average Cost
<Issuer_3>	<Asset_3>	<Country of Domicile_1>	<Moodys Rating_2>	<Maturity Date_1>	<Coupon Spread_1>	<Average Cost_1>
<deleterow>
					0.00	0.00
</Category for HYSL Report_3_Level>
</Type for HYSL Report_2_Level>

PDF output:

How can I avoid these NULL entries in reporting?
Is there any condition I can put either in Excel or Qlik side that when this report gets generated it should avoid this?