Select Distinct 2 fields?

[tsiuak]

Hi everyone! 😀

I need a big favor. I just started using Qlik Sense.

I would like that 'Agent 1' (img_1.png) to become 'Cod Agente' (img_2.png).

'Cod Agente' means Agent Code.

It means we have to select all the 'Agent 1' and all the 'Agent 2', but separately.

A same Agent can be number 1 in a specific order, or can also be number 2 (but only in a different order).

Does anyone have any ideas?

Many thanks in advance!

[tsiuak]

Nobody? 😢