Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | ||||
Hi, as below.
=Sum(Aggr(Only(salary),Name))
Try this
aggr(only(salary), Name)
@Glynn1969 you can simply use below
= max(Salary)