topic Re: Agregation Function not working in QlikView

Agregation Function not working

Mario_ES — Fri, 12 Nov 2021 12:22:01 GMT

Hello,

I have a simple table of employees with multiple fields one of which the is the degree. Each level of degree has an spefic code assigned by the goverment based on hierarchy j: PHD 61, Masters Degree 59, University degree...

The problem is tha many of them have more than one degree and causes the rows to multiply one for each degree.

I want to only show the degree with the maximum code number. I have tried this formula and it's not working:

IF(AGGR([Degree Code]=MAX([Degree Code]),EmployeeNumber), "Degree's Name")

Can you please help.

Re: Agregation Function not working

Gysbert_Wassenaar — Fri, 12 Nov 2021 14:40:54 GMT

perhaps this works: firstsortedvalue([Degree's Name], -[Degree Code])

Re: Agregation Function not working

Mario_ES — Mon, 15 Nov 2021 09:32:00 GMT

I have tried it out and it's not working.

This formula works, but returns the minimum value:

FirstSortedValue(Degree,aggr([Degree Code]=max([Degree Code]),EmployeeNum))

Can someone tell me how can I do to return the max instead, please!