DASHBOARD TABLE FORMAT PROBLEM

[gabroteddy]

HI,

I have a table that give me in output the following fromat

ID	OPERATOR	PROCEDURE	MATERIAL
100	A	123	Y
100	B	123	Z
100	A	123	X
100	B	123	W
100	A	456	Y
100	B	456	Z
100	A	456	X
100	B	456	W

What I want is agggregate the duplicate value in one row (like a cell union in excel).

How I ca do it in qlik?

Regards!

[sunny_talwar]

Not sure what you are looking to get to? and where (Script or front end of the app)?

[Wlad_Masi]

Instead of "procedure" you have to use sum(procedure) as a measure.
If you do it, you will have the values summed up for rows with the same Operator, ID and Material.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.