topic Re: How to merge table cells? in App Development

How to merge table cells?

YanivZi — Tue, 12 Dec 2023 19:56:29 GMT

I would like to ask about the possibility of merging cells in a standard table chart in Qlik Sense. I understand that the vizlib library has functionality to merge cells, however I am working with a plain table chart (not a pivot table).

Could you please advise if merging cells is supported in the native Qlik Sense table visualization? If not, are there any workarounds that could simulate this and are not 3rd party extension?

Example:

City	Country	Continent
New York	United States	America
Washington	United States	America
Paris	France	Europe
Shanghai	China	Asia
Hong Kong	China	Asia

Re: How to merge table cells?

MatheusC — Tue, 12 Dec 2023 20:37:43 GMT

@YanivZi

See about the concat() function

https://help.qlik.com/pt-BR/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringAggregationFunctions/concat.htm#:~:text=Concat()%20%C3%A9%20used %20to,by%20a%20cl%C3%A1usula%20group%20by.

1 example - concat(distinct field,',') -> separator by ,
2 example - =replace(concat(distinct field,','),',',chr(10)) -> for line breaks

Analyze the best way, I advise playing a role in the script. But it also works by expression

Att,

Matheus

Re: How to merge table cells?

Or — Tue, 12 Dec 2023 22:13:40 GMT

As far as I know, this is not supported and there are no workarounds with the native object.

As you seem to be aware of, you can get this done using a pivot table, or using extensions. You could try your luck with an Ideation request for this, but that would be more of a longer-term option and I wouldn't have much confidence in it being picked up by Qlik.

Re: How to merge table cells?

YanivZi — Wed, 13 Dec 2023 05:44:39 GMT

In pivot the content of the table is measures (numeric) and i want to use text. right?

Re: How to merge table cells?

YanivZi — Wed, 13 Dec 2023 05:45:48 GMT

this did work, the search not looking good though 🙃

thanks

Re: How to merge table cells?

Or — Wed, 13 Dec 2023 09:27:48 GMT

Measures don't differ between tables and pivot tables, as far as I know. You can use numeric ones or textual ones - you just have to make sure that whatever data structure or aggregation you use returns a single value for each measure cell.

Re: How to merge table cells?

MatheusC — Wed, 13 Dec 2023 11:54:19 GMT

@YanivZi

This is a solution depending on the need, as it is an expression the search will not be enabled, hence the idea of taking the Concat() function to the script editor creating a new field for these values together with the group by clause function

Example
Load
fieldA,
fieldB,
replace(concat(distinctCfield,','),',',chr(10)) as newCampo
resident table group by campoA,campoB;

This way it will be possible to filter using the new Field, but as expected the search will present the addition of the Concat() function. It may not be the best way. You will need to analyze whether it is viable, Then see the recommendations.

Greetings
Matheus