Solved: Re: Nprinting - Merge Cells in table in HTML - Qlik Community

sogloqlik · ‎2022-05-24

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.

Ruggero_Piccoli · ‎2022-05-24

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Ruggero_Piccoli · ‎2022-05-24

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

David_Friend · ‎2022-05-24

What SR of May 2021 are you on?

sogloqlik · ‎2022-05-25

Hi David.

Our version is : 21.14.3.0

sogloqlik · ‎2022-05-25

Hi.

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

Thank you

Nprinting - Merge Cells in table in HTML

Qlik NPrinting May 2021

Qlik Sense