# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for
Did you mean:
Partner

## Combing IF-statement with Aggr()

Hi,

I'm using the code below to identify the top five performers and now I want get the average of those top five performers.

If(Rank(TOTAL SUM({\$<

[CompanyName]=,

[XBRL Reporting year]={\$(vXBRLThisYear)},

industry={\$(vChosenIndustry)}>}

[Årets resultat]))<=5,

SUM({\$<

[CompanyName]=,

[XBRL Reporting year]={\$(vXBRLThisYear)},

industry={\$(vChosenIndustry)}>}

[GrossResult]))

I have tried an aggr() function, but have not managed to succeed.

Does anyone have idea how to get the average value of top 5?

1 Solution

Accepted Solutions
MVP

This isn't working?

Avg({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry={\$(vChosenIndustry)}>} Aggr(

If(Rank(TOTAL SUM({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry = {\$(vChosenIndustry)}>} [Årets resultat])) <= 5, Sum({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry = {\$(vChosenIndustry)}>} [GrossResult]))

, Performer))

4 Replies
MVP

This isn't working?

Avg({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry={\$(vChosenIndustry)}>} Aggr(

If(Rank(TOTAL SUM({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry = {\$(vChosenIndustry)}>} [Årets resultat])) <= 5, Sum({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry = {\$(vChosenIndustry)}>} [GrossResult]))

, Performer))

Partner
Author

Unfortunately not. No value is shown. But I don't understand where 'Performer' comes from?

MVP

It came from your description of the problem

I guess Performer is not a field name, but is rather called something else... replace Performer with the field which shows performers

Partner
Author

It worked!! Thank you very much and have a nice day 🙂