topic Re: DASHBOARD TABLE FORMAT PROBLEM in App Development

DASHBOARD TABLE FORMAT PROBLEM

gabroteddy — Mon, 14 Jan 2019 22:36:15 GMT

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!

Re: DASHBOARD TABLE FORMAT PROBLEM

sunny_talwar — Tue, 15 Jan 2019 01:11:04 GMT

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

Re: DASHBOARD TABLE FORMAT PROBLEM

Wlad_Masi — Wed, 13 Mar 2019 21:01:32 GMT

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.