topic Re: 2 Table overlapping side by side in Qlik Reporting (Excel Add-In) in Reporting Service & Alerting

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

prads_uk_2025 — Tue, 02 Sep 2025 15:28:41 GMT

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.

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

Frank_S — Tue, 02 Sep 2025 18:28:22 GMT

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

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

Lech_Miszkiewicz — Wed, 03 Sep 2025 05:27:49 GMT

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

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

prads_uk_2025 — Wed, 03 Sep 2025 09:34:25 GMT

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.

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

prads_uk_2025 — Wed, 03 Sep 2025 09:35:22 GMT

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.

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

Lech_Miszkiewicz — Wed, 03 Sep 2025 10:14:59 GMT

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

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

prads_uk_2025 — Wed, 03 Sep 2025 11:11:31 GMT

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?

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

Lech_Miszkiewicz — Wed, 03 Sep 2025 11:48:23 GMT

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

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

prads_uk_2025 — Wed, 03 Sep 2025 12:07:44 GMT

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.

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

prads_uk_2025 — Thu, 04 Sep 2025 08:35:05 GMT

@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?

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

Lech_Miszkiewicz — Thu, 04 Sep 2025 09:06:25 GMT

Hi @prads_uk_2025

This community is to focus on subject of the post "2 Table overlapping side by side in Qlik Reporting (Excel Add-In)". The point of which is to stick to the subject. Your latest question is totally unrelated so best thing to do to discuss it further would be to create proper new topic.

I will just comment in one sentence: To remove null values from levels for which you have no data you need to build your levels of the tables (not only fields) and base them on the fact that you disable null values in the table dimensions as well as supress zero values from measures!

If you need more explanation please create new subject and tag me and we can take it from there.

cheers

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

prads_uk_2025 — Thu, 04 Sep 2025 09:08:40 GMT

Yes, I have created. Apologies for it.
Remove or Do Not show the NULL values / rows / Lev... - Qlik Community - 2529363