Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Merging rows containing same value

Hi. I have a table that has only dimensions & no Expressions.

Here are the first few rows .

TaskSub Task
Task 1A
Task 1B
Task 2C
Task 2D
Task 2E

I want to do a merge & center like we would do in excel in a similar situation.

TaskSub Task
Task 1A
B
Task 2C
D
E

How can this be implemented using a table box?

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No, that cannot be implemented using a table box. You need an expression for that and therefore a chart object like a straight table or pivot table with Task as dimension and as expression concat(distinct [Sub Task], chr(10)).


talk is cheap, supply exceeds demand
marcus_sommer

A tablebox could only show data how they are - you will need a table-chart and could use a calculated dimension or an expression like this:

concat(distinct [Sub Task], chr(10))

- Marcus

Not applicable
Author

This does not work.

tresesco
MVP
MVP

May be like attached sample.

Edit: If you are interested in values without line separator, have a look at the second chart.