topic Re: Top and Low values in bar chart in QlikView https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671326#M1075858 <HTML><HEAD></HEAD><BODY><P>You have to understand that set analysis doesn't work row-wise of a chart, it's a global filter. Therefore, you might have to try with Aggr(Rank(... combination for a chart; its depends on dimensions. </P></BODY></HTML> Tue, 29 Jul 2014 05:53:00 GMT tresB 2014-07-29T05:53:00Z Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671323#M1075855 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i want to display top 10 and lowest 10 values based on sales in bar chart</P><P></P><P><SPAN style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">SUM({&lt;Customer = {"=Rank(-SUM(Sales),4)&lt;=10"}&gt;}</SPAN><SPAN style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">Sales)</SPAN> i got this for lowest value.</P><P></P><P>how to show both values any help? </P></BODY></HTML> Tue, 29 Jul 2014 05:40:55 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671323#M1075855 arulsettu 2014-07-29T05:40:55Z Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671324#M1075856 <HTML><HEAD></HEAD><BODY><P>Try:</P><P><SPAN style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #666666;">SUM({&lt;Customer = {"=Rank(-SUM(Sales),4)&lt;=10&nbsp; <STRONG>or</STRONG> <SPAN style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">Rank(SUM(Sales),4)&lt;=10</SPAN>&nbsp; "}&gt;}</SPAN><SPAN style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #666666;">Sales)</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN></P></BODY></HTML> Tue, 29 Jul 2014 05:45:49 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671324#M1075856 tresB 2014-07-29T05:45:49Z Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671325#M1075857 <HTML><HEAD></HEAD><BODY><P>HI</P><P>it showing many values i need to display only 10 and how to identify the lowest values in this chart?</P><P></P><P></P><P>thank you</P></BODY></HTML> Tue, 29 Jul 2014 05:49:41 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671325#M1075857 arulsettu 2014-07-29T05:49:41Z Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671326#M1075858 <HTML><HEAD></HEAD><BODY><P>You have to understand that set analysis doesn't work row-wise of a chart, it's a global filter. Therefore, you might have to try with Aggr(Rank(... combination for a chart; its depends on dimensions. </P></BODY></HTML> Tue, 29 Jul 2014 05:53:00 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671326#M1075858 tresB 2014-07-29T05:53:00Z Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671327#M1075859 <HTML><HEAD></HEAD><BODY><P>my dimension is customer</P></BODY></HTML> Tue, 29 Jul 2014 05:55:25 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671327#M1075859 arulsettu 2014-07-29T05:55:25Z Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671328#M1075860 <HTML><HEAD></HEAD><BODY><P>and it is possible to display like this</P><P><IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/63283_Capture.JPG.jpg" /></P></BODY></HTML> Tue, 29 Jul 2014 05:57:52 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671328#M1075860 arulsettu 2014-07-29T05:57:52Z Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671329#M1075861 <HTML><HEAD></HEAD><BODY><P>Could you post a sample qvw? See: <A href="http://community.qlikview.com/docs/DOC-1290" title="http://community.qlikview.com/docs/DOC-1290">Preparing examples for Upload - Reduction and D... | Qlik Community</A></P></BODY></HTML> Tue, 29 Jul 2014 05:58:58 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671329#M1075861 tresB 2014-07-29T05:58:58Z Re: Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671330#M1075862 <HTML><HEAD></HEAD><BODY><P>ok please wait i will post the app</P></BODY></HTML> Tue, 29 Jul 2014 06:17:05 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671330#M1075862 arulsettu 2014-07-29T06:17:05Z Re: Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671331#M1075863 <HTML><HEAD></HEAD><BODY><P>here it is</P></BODY></HTML> Tue, 29 Jul 2014 06:43:21 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671331#M1075863 arulsettu 2014-07-29T06:43:21Z Re: Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671332#M1075864 <HTML><HEAD></HEAD><BODY><P>any idea?</P></BODY></HTML> Tue, 29 Jul 2014 07:00:02 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671332#M1075864 arulsettu 2014-07-29T07:00:02Z Re: Re: Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671333#M1075865 <HTML><HEAD></HEAD><BODY><P>Values are there and you don't see them(lowest 10) because all of them are zeros and your zero suppression was enabled in the presentation tab. PFA</P></BODY></HTML> Tue, 29 Jul 2014 07:13:27 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671333#M1075865 tresB 2014-07-29T07:13:27Z Re: Re: Re: Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671334#M1075867 <HTML><HEAD></HEAD><BODY><P>i copied same thing into another app i am getting this result.</P><P>why it is different from another?</P></BODY></HTML> Tue, 29 Jul 2014 07:22:35 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671334#M1075867 arulsettu 2014-07-29T07:22:35Z Re: Re: Re: Re: Top and Low values in bar chart https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671335#M1075870 <HTML><HEAD></HEAD><BODY><P>any help?</P></BODY></HTML> Tue, 29 Jul 2014 07:37:07 GMT https://community.qlik.com/t5/QlikView/Top-and-Low-values-in-bar-chart/m-p/671335#M1075870 arulsettu 2014-07-29T07:37:07Z