Count field value based on unique values in a 2nd field

[Glynn1969]

Hello i am very new (2days) into Qlik so apologies for basic question and also sorry if i'm in the wrong forum.

i have simplified my data below but in short i want to use an expression in  pivot table to so the salaries for an individual - at the moment my pivot is multiplying my salary data and inflating salaries. 

How can i just count a single salary value per unique name

Name	salary		result	correct	incorrect
Ann	50,000		Ann	50,000	150,000
Ann	50,000		Brian	45,000	90,000
Ann	50,000		Col	25,000	100,000
Brian	45,000		Dave	60,000	120,000
Brian	45,000
Col	25,000
Col	25,000
Col	25,000
Col	25,000
Dave	60,000
Dave	60,000

[BrunPierre · Accepted solution]

Hi, as below.

=Sum(Aggr(Only(salary),Name))

[Chanty4u]

Try this

aggr(only(salary), Name)

[Kushal_Chawda]

@Glynn1969   you can simply use below

= max(Salary)