topic Re: Merging data into single cell Pivot in QlikView

Merging data into single cell Pivot

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have data with three dimensions . I want to merge the data of a column into single row. Please find below screenshot for easy understanding of requirement.

Regards,

Sai Krishna.

Re: Merging data into single cell Pivot

sunny_talwar — Mon, 09 May 2016 16:59:41 GMT

Check here:

Re: Pivot table issue

Re: Merging data into single cell Pivot

Mon, 09 May 2016 21:02:05 GMT

Temp:

Load * Inline [

Sno, ProductFamily, Product, Category, Qty

1, Accessories, Mouse, Hardware, 2

2, Accessories, Keyboard, Hardware, 3

3, Accessories, Headset, Hardware, 1

4, Computer, Windows, Software, 1

5, Computer, Office, Software, 1

];

Final:

Load

ProductFamily, Category,

Concat(Product, ',') as Product,

sum(Qty) as Qty

Resident Temp

Group by ProductFamily, Category;

Drop table Temp;

Re: Merging data into single cell Pivot

sorrakis01 — Mon, 09 May 2016 21:05:28 GMT

HI,

It's the same question and the same example

Regards,