topic Waterfall chart with top bottom products in App Development https://community.qlik.com/t5/App-Development/Waterfall-chart-with-top-bottom-products/m-p/95422#M6358 <HTML><HEAD></HEAD><BODY><P>Hi Friends, </P><P></P><P>I want to create one waterfall chart in qliksesne , where middle part should show the top 5 product and bottom 5 products </P><P>like below, </P><P>How can i achieve that?</P><P></P><P><IMG alt="requirement.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209608_requirement.jpg" style="height: 141px; width: 620px;" /></P><P></P><P>thanks</P></BODY></HTML> Wed, 01 Aug 2018 16:03:17 GMT agni_gold 2018-08-01T16:03:17Z Waterfall chart with top bottom products https://community.qlik.com/t5/App-Development/Waterfall-chart-with-top-bottom-products/m-p/95422#M6358 <HTML><HEAD></HEAD><BODY><P>Hi Friends, </P><P></P><P>I want to create one waterfall chart in qliksesne , where middle part should show the top 5 product and bottom 5 products </P><P>like below, </P><P>How can i achieve that?</P><P></P><P><IMG alt="requirement.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209608_requirement.jpg" style="height: 141px; width: 620px;" /></P><P></P><P>thanks</P></BODY></HTML> Wed, 01 Aug 2018 16:03:17 GMT https://community.qlik.com/t5/App-Development/Waterfall-chart-with-top-bottom-products/m-p/95422#M6358 agni_gold 2018-08-01T16:03:17Z Re: Waterfall chart with top bottom products https://community.qlik.com/t5/App-Development/Waterfall-chart-with-top-bottom-products/m-p/95423#M6359 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>may be you can try to use aggr an rank functions in your set analysis to calculate the top 5 product</P><P>and the bottom 5&nbsp; (it's a little bit tricky for this part, please refer to this thread : <A _jive_internal="true" href="https://community.qlik.com/thread/114365">https://community.qlik.com/thread/114365</A></P><P></P><P>here a thread for the ranking : <A href="https://community.qlikview.com/thread/31372">https://community.qlikview.com/thread/31372</A></P><P>and for the aggr : <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2016/03/07/set-analysis-in-the-aggr-function">https://community.qlik.com/blogs/qlikviewdesignblog/2016/03/07/set-analysis-in-the-aggr-function</A></P><P></P><P>Hope it helps you</P><P></P><P>A.</P></BODY></HTML> Wed, 01 Aug 2018 19:17:24 GMT https://community.qlik.com/t5/App-Development/Waterfall-chart-with-top-bottom-products/m-p/95423#M6359 s_achraphe 2018-08-01T19:17:24Z