Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.