Can we please help on this scenario in Qlikview

[Naps_230]

Hi,

Please find below details.

How to find out this output.

I/P-

WD	PLANT	QTY
A	X	5
A	Y	5
A	Z	5
B	Y	7
C	X	2
C	Z	5

O/P-

WD	PLANT	QTY
A	XYZ	15
B	Y	7
C	XZ	7

[jaumecf23]

Try this :

Final:

Load

   WD,

   Concat(PLANT) as PLANT,

   sum(QTY) as QTY

Resident Temp

Group by WD;