topic Re: Merging rows containing same value in QlikView

Merging rows containing same value

Fri, 17 Oct 2014 10:48:01 GMT

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

Here are the first few rows .

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

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

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

How can this be implemented using a table box?

Re: Merging rows containing same value

Gysbert_Wassenaar — Fri, 17 Oct 2014 11:10:15 GMT

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)).

Re: Merging rows containing same value

marcus_sommer — Fri, 17 Oct 2014 11:12:47 GMT

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

Re: Merging rows containing same value

Mon, 27 Oct 2014 06:53:17 GMT

This does not work.

Re: Re: Merging rows containing same value

tresB — Mon, 27 Oct 2014 07:06:36 GMT

May be like attached sample.

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