topic Re: How to merge multiple rows into single row in qlikview in QlikView

How to merge multiple rows into single row in qlikview

djaykumar — Sat, 16 Nov 2024 19:42:53 GMT

Hi,

I am struggling to merge multiple rows into single.

Please find below data

Material Description Quantity

24 Bolt 25

24 Bolt 6

25 Bush 10

26 Copper Cover 2

26 Copper Cover 6

Required output

Material Description Quantity

24 Bolt 31

25 Bush 10

26 Copper Cover 8

When I am using Straight table or pivot table I am getting Required output . But My requirement is The requirement output should come in Table Box.

Please help me in this.

Thanks

Jay

Re: How to merge multiple rows into single row in qlikview

StarinieriG — Fri, 08 Nov 2019 11:10:41 GMT

Hi,

to do that you have to use group by in the script.

Load

Material

Description

Sum(Quantity) as Quantity

from ....

group by

Material,

Description

;

Re: How to merge multiple rows into single row in qlikview

djaykumar — Fri, 08 Nov 2019 11:20:29 GMT

Hi StarinieriG,

Thanks for quick reply

But without giving quantity in group by I am getting 'Invalid expression' error.

Please help me

Thanks,

Jay

Re: How to merge multiple rows into single row in qlikview

StarinieriG — Fri, 08 Nov 2019 11:23:27 GMT

It's because you can't keep Quantity as dimension.

If you want to keep each distinct rows, you could create a new table (using the script that I suggested before) and then call the sum(quantity) in another way

Re: How to merge multiple rows into single row in qlikview

djaykumar — Fri, 08 Nov 2019 11:40:39 GMT

Hi StarinieriG,

According to you I am getting doubled the quantity as below

Material Description Quantity

24 Bolt 62

25 Bush 10

26 Copper Cover 16

Thanks

Jay

Re: How to merge multiple rows into single row in qlikview

StarinieriG — Fri, 08 Nov 2019 11:44:54 GMT

Try to see file attached