topic Re: All item total vs filtered single item total in bar chart in App Development https://community.qlik.com/t5/App-Development/All-item-total-vs-filtered-single-item-total-in-bar-chart/m-p/84054#M5601 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Sum(Aggr(IF(Currency = 'THB', SUM(GRAmount)*vThaiRate, SUM(GRAmount)*1),<SPAN style="color: #ff0000;"> Sub_category, Currency</SPAN>))</STRONG></P></BODY></HTML> Thu, 24 May 2018 12:13:25 GMT sunny_talwar 2018-05-24T12:13:25Z All item total vs filtered single item total in bar chart https://community.qlik.com/t5/App-Development/All-item-total-vs-filtered-single-item-total-in-bar-chart/m-p/84053#M5600 <HTML><HEAD></HEAD><BODY><P>Hi I have a problem where the value shown when highlighted an item and showing all is different in the bar chart.</P><P></P><P><IMG alt="" class="jive-image image-1" height="294" src="https://community.qlik.com/legacyfs/online/203330_pastedImage_0.png" style="width: 630.727px; height: 294px;" width="631" /></P><P>Once filtered, the value is correct</P><P></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/203331_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>What's the issue. Ill upload the QVF file together !</P></BODY></HTML> Sat, 16 Nov 2024 08:13:20 GMT https://community.qlik.com/t5/App-Development/All-item-total-vs-filtered-single-item-total-in-bar-chart/m-p/84053#M5600 Anonymous 2024-11-16T08:13:20Z Re: All item total vs filtered single item total in bar chart https://community.qlik.com/t5/App-Development/All-item-total-vs-filtered-single-item-total-in-bar-chart/m-p/84054#M5601 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Sum(Aggr(IF(Currency = 'THB', SUM(GRAmount)*vThaiRate, SUM(GRAmount)*1),<SPAN style="color: #ff0000;"> Sub_category, Currency</SPAN>))</STRONG></P></BODY></HTML> Thu, 24 May 2018 12:13:25 GMT https://community.qlik.com/t5/App-Development/All-item-total-vs-filtered-single-item-total-in-bar-chart/m-p/84054#M5601 sunny_talwar 2018-05-24T12:13:25Z Re: All item total vs filtered single item total in bar chart https://community.qlik.com/t5/App-Development/All-item-total-vs-filtered-single-item-total-in-bar-chart/m-p/84055#M5602 <HTML><HEAD></HEAD><BODY><P>this works, and solved</P></BODY></HTML> Fri, 25 May 2018 00:49:38 GMT https://community.qlik.com/t5/App-Development/All-item-total-vs-filtered-single-item-total-in-bar-chart/m-p/84055#M5602 Anonymous 2018-05-25T00:49:38Z