topic Re: Nprinting - Merge Cells in table in HTML in Qlik NPrinting

Nprinting - Merge Cells in table in HTML

sogloqlik — Tue, 24 May 2022 08:05:05 GMT

Hi all.

I Have a Table which holds for each Product category the top 5 products.
A basic strait table is no problem (file attached), but I want to merge the Category cells for each category.
It looks s like a pivot but supposed to be much easier.
When I try to use the row span, I get the most bizarre result
I've attached the HTML code also. some of the names are in Hebrew but row span appears only once
Any help would be appreciated.

Thx.

Re: Nprinting - Merge Cells in table in HTML

Ruggero_Piccoli — Tue, 24 May 2022 13:39:53 GMT

Hi,

You can evaluate to use Levels for the Category field and nested HTML tables:

Result:

HTML code:

<html> <body> %%Year_Level%% <table border="1px" bordercolor="#00C853"> <tr> <td>%%Year%%</td> <td> <table> <tr> <td>%%Country%%</td> <td>%%Total Sales%%</td> </tr> </table> </td> </tr> </table> %%/Year_Level%% </body> </html>

Best Regards,

Ruggero

Re: Nprinting - Merge Cells in table in HTML

David_Friend — Tue, 24 May 2022 18:26:20 GMT

What SR of May 2021 are you on?

Re: Nprinting - Merge Cells in table in HTML

sogloqlik — Wed, 25 May 2022 04:28:49 GMT

Hi David.

Our version is : 21.14.3.0

Re: Nprinting - Merge Cells in table in HTML

sogloqlik — Wed, 25 May 2022 10:06:46 GMT

Hi.

Merge cells would have been better but for now it is good enough.

Thank you