IF Statement that returns the Email Address for the Top 10 Results

[DataHound]

Hello All,

Goal: I would like to return a concatenated list of the email addresses associated with the top 10 results of a measure. 

I have a table that updates daily with the top 10 employees based on a measure. I would like to have qlik create a list of the email addresses associated with these employees. I have the Dimension of email in the data. 

I am thinking of placing my current formula for the calculation into an IF statement that returns the email addresses only if they  are in the Top 10 of the results for that measure.

Measure: (SUM(SALES))/(COUNT(CONTACTS))

EMAIL is the dimension 

[rubenmarin · Accepted solution]

Hi, try with: Concat(Distinct {<Email={"=Rank(SUM(SALES))/(COUNT(CONTACTS))<=10"}>} Email,';')

[DataHound]

Thank you! This worked as my solution.