topic Logic Help... in QlikView https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948867#M954222 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>i have to show site name, the site which is best...</P><P>i bar chart i tool dimension Site and count(SiteId) as Measure..</P><P>i want the best site and worst site name to display in text box..</P><P></P><P>How i can do this?</P></BODY></HTML> Fri, 20 Nov 2015 10:03:34 GMT abhaysingh 2015-11-20T10:03:34Z Logic Help... https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948867#M954222 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>i have to show site name, the site which is best...</P><P>i bar chart i tool dimension Site and count(SiteId) as Measure..</P><P>i want the best site and worst site name to display in text box..</P><P></P><P>How i can do this?</P></BODY></HTML> Fri, 20 Nov 2015 10:03:34 GMT https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948867#M954222 abhaysingh 2015-11-20T10:03:34Z Re: Logic Help... https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948868#M954223 <HTML><HEAD></HEAD><BODY><P>For worst site&nbsp; below expression in Text object</P><P></P><P>=Firstsortedvalue(Site, aggr(Count(SiteID), Site) &amp;':' &amp; Firstsortedvalue(sum(aggr(Count(SiteID), Site)), aggr(Count(SiteID),Site))</P><P></P><P></P><P>For Best site&nbsp; below expression in Text object</P><P></P><P>=Firstsortedvalue(Site, -aggr(Count(SiteID), Site) &amp;':' &amp; Firstsortedvalue(sum(aggr(Count(SiteID), Site)), -aggr(Count(SiteID),Site))</P></BODY></HTML> Fri, 20 Nov 2015 10:09:48 GMT https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948868#M954223 Kushal_Chawda 2015-11-20T10:09:48Z Re: Logic Help... https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948869#M954224 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>what is the error in expression?</P></BODY></HTML> Fri, 20 Nov 2015 10:42:03 GMT https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948869#M954224 abhaysingh 2015-11-20T10:42:03Z Re: Logic Help... https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948870#M954225 <HTML><HEAD></HEAD><BODY><P>one bracket is missing. Try this</P><P></P><P>=Firstsortedvalue(Site, aggr(Count(SiteID), Site)) &amp;':' &amp; Firstsortedvalue(sum(aggr(Count(SiteID), Site)), aggr(Count(SiteID),Site))</P><P></P><P></P><P>For Best site&nbsp; below expression in Text object</P><P></P><P>=Firstsortedvalue(Site, -aggr(Count(SiteID), Site)) &amp;':' &amp; Firstsortedvalue(sum(aggr(Count(SiteID), Site)), -aggr(Count(SiteID),Site))</P></BODY></HTML> Fri, 20 Nov 2015 10:45:11 GMT https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948870#M954225 Kushal_Chawda 2015-11-20T10:45:11Z Re: Logic Help... https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948871#M954226 <HTML><HEAD></HEAD><BODY><P>still error</P></BODY></HTML> Fri, 20 Nov 2015 10:49:48 GMT https://community.qlik.com/t5/QlikView/Logic-Help/m-p/948871#M954226 abhaysingh 2015-11-20T10:49:48Z