Solved: Merge Rows - Qlik Community

KHSDM · ‎2019-08-26

Hi all,

I want to create a report in Nprinting in the format below. I tried to use excel, but I can't get it in the format that I want. Such as merging the cells. (refer to column A in the sample below) Any idea what I can do so that I can achieve this format. (The value of Actual/Budget is a mixture of percentage and integer)

Ruggero_Piccoli · ‎2019-08-27

Hi,

With Levels you could create something similar to:

Then you can use Excel conditional formatting rules, for example for the Country column, and create a rule that formats the duplicated cells from the second as white text on white background:

In the resulted report only the first value appears:

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 · ‎2019-08-26

Hi,

I think you are experiencing this documented know limitation:

Keep Source Format option does not keep Excel merged cells
Excel merged cells are not supported for Qlik NPrinting tags regardless of Keep Source Format option.

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.

KHSDM · ‎2019-08-26

Hi Ruggero,

Any workaround or tricks? Tried to use levels, but can't format it like what I want.

Arthur_Fong · ‎2019-08-26

Hi Khim Hoe,

Does this help?

Or cells must be merged?

Thanks and regards,

Arthur Fong

Ruggero_Piccoli · ‎2019-08-27

Hi,

With Levels you could create something similar to:

Then you can use Excel conditional formatting rules, for example for the Country column, and create a rule that formats the duplicated cells from the second as white text on white background:

In the resulted report only the first value appears:

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.

KHSDM · ‎2019-08-28

HI Arthur,
Yes, cells must be merged or look merged when printed with borders.

KHSDM · ‎2019-08-28

Thanks for the tips! Manage to format it using the conditional formatting in Excel. 😄

Merge Rows

Related Topics