Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,