Merge cells

[Manni_SM]

Hi @Lech_Miszkiewicz   

i want to merge the cells  if cell values is matching  like below  in excel and pixel perfect NP

field 1   | Field2 | Feild3 

1,2,3

1,4,5

1,6,7

now my result  should be in excel template 

      2,3

1    4,5

      6,7

[Lech_Miszkiewicz]

Hi @Manni_SM 

You may want to give us use case to better understand as to:

• why you need to do this in XLSX and Pixel Perfect template
  • the ways to do that in both tables are very different and depend on the use case
• For excel - Can't you use native pivot table which will do this grouping for you?
  • https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/a...
• For excel -  you may as well use excel conditional formatting (excel based function to colour code cell values and borders in straight table to make it look like they are merged although they would not be
• For excel - you may as well use levels to mimic similar layout
• For pixel perfect - there is no native option - it is just a matter of creating data in data source (qlik app table) which then you can use in conditional formatting of the table (this is time consuming task) to create grouping lookalike view by managing borders display and font colour display. Below link gives you idea how to conditional format things in pixel perfect. The same applies to borders
  • https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/PixelPe...

cheers