https://community.qlik.com/t5/App-Development/IF-Statement-that-returns-the-Email-Address-for-the-Top-10/m-p/2004073#M83126 <P>Thank you! This worked as my solution.</P> Mon, 14 Nov 2022 12:02:35 GMT DataHound 2022-11-14T12:02:35Z https://community.qlik.com/t5/App-Development/IF-Statement-that-returns-the-Email-Address-for-the-Top-10/m-p/2001756#M82978 <P>Hello All,</P> <P>Goal: I would like to return a concatenated list of the email addresses associated with the top 10 results of a measure.&nbsp;</P> <P>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.&nbsp;</P> <P>I am thinking of placing my current formula for the calculation into an IF statement that returns the email addresses only if they&nbsp; are in the Top 10 of the results for that measure.</P> <P>Measure: (SUM(SALES))/(COUNT(CONTACTS))</P> <P>EMAIL is the dimension&nbsp;</P> Tue, 08 Nov 2022 13:57:55 GMT https://community.qlik.com/t5/App-Development/IF-Statement-that-returns-the-Email-Address-for-the-Top-10/m-p/2001756#M82978 DataHound 2022-11-08T13:57:55Z https://community.qlik.com/t5/App-Development/IF-Statement-that-returns-the-Email-Address-for-the-Top-10/m-p/2001772#M82981 <P>Hi, try with:&nbsp;Concat(Distinct {&lt;Email={"=Rank(<SPAN>SUM(SALES))/(COUNT(CONTACTS)</SPAN>)&lt;=10"}&gt;} Email,';')</P> Tue, 08 Nov 2022 14:18:30 GMT https://community.qlik.com/t5/App-Development/IF-Statement-that-returns-the-Email-Address-for-the-Top-10/m-p/2001772#M82981 rubenmarin 2022-11-08T14:18:30Z https://community.qlik.com/t5/App-Development/IF-Statement-that-returns-the-Email-Address-for-the-Top-10/m-p/2004073#M83126 <P>Thank you! This worked as my solution.</P> Mon, 14 Nov 2022 12:02:35 GMT https://community.qlik.com/t5/App-Development/IF-Statement-that-returns-the-Email-Address-for-the-Top-10/m-p/2004073#M83126 DataHound 2022-11-14T12:02:35Z