How can I show multiple data on dynamic text measure?

[rushi_kale_01]

I am working on the Dynamic display of texts as per the filters. So, if I am selecting a certain company for a particular year, I want to show the top 5 department names in the Text box along with its revenue.

How can I do this? Any help is greatly appreciated.

Thanks in advance 

[RafaelBarrios]

Hi @rushi_kale_01 

For top 5 you will need to use the rank
https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ra...

then combine it with aggr

Aggr(rank(< rank options in documentation >),department)

and after that use concat to split en values 

=Concat(Aggr(rank(< rank options in documentation >),department),'|')

that should return something like

dep1|dep2|dep3|dep4|dep5

but could have some syntax error, couldn’t tried.

hope this helps.

best,