Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Merging rows containing same value

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

Re: Merging rows containing same value

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

Re: Merging rows containing same value

This does not work.

MVP
MVP

Re: Re: Merging rows containing same value

May be like attached sample.

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

Community Browser