Waterfall chart with top bottom products

[agni_gold]

Hi Friends,

I want to create one waterfall chart in qliksesne , where middle part should show the top 5 product and bottom 5 products

like below,

How can i achieve that?

thanks

[s_achraphe]

Hello

may be you can try to use aggr an rank functions in your set analysis to calculate the top 5 product

and the bottom 5  (it's a little bit tricky for this part, please refer to this thread : https://community.qlik.com/thread/114365

here a thread for the ranking : https://community.qlikview.com/thread/31372

and for the aggr : https://community.qlik.com/blogs/qlikviewdesignblog/2016/03/07/set-analysis-in-the-aggr-function

Hope it helps you

A.