https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1940933#M1219331 <P>Maybe something like: sum(<STRONG>{&lt; Unit = {1}&gt;}</STRONG> [Average Load (Actual)])</P> <P>- Marcus</P> Wed, 08 Jun 2022 10:53:11 GMT marcus_sommer 2022-06-08T10:53:11Z https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1940798#M1219325 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ejriri_0-1654675466521.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/81210i00474C831E43A9B7/image-size/medium?v=v2&amp;px=400" role="button" title="ejriri_0-1654675466521.png" alt="ejriri_0-1654675466521.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ejriri_1-1654675638335.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/81211iDF02FE6330EFF87C/image-size/medium?v=v2&amp;px=400" role="button" title="ejriri_1-1654675638335.png" alt="ejriri_1-1654675638335.png" /></span></P> <P>&nbsp;</P> <P>Hi. Please help me with this one.</P> <P>First photo is the the sample of my excel file.&nbsp;</P> <P>How can I make that my bar chart will only appear the average of Unit 1 only without using filter pane?&nbsp;</P> <P>The second photo should be the appearance of my graph but unit 1 Actual and Target Load should be shown only.&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 08 Jun 2022 08:12:25 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1940798#M1219325 ejriri 2022-06-08T08:12:25Z https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1940933#M1219331 <P>Maybe something like: sum(<STRONG>{&lt; Unit = {1}&gt;}</STRONG> [Average Load (Actual)])</P> <P>- Marcus</P> Wed, 08 Jun 2022 10:53:11 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1940933#M1219331 marcus_sommer 2022-06-08T10:53:11Z https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1940963#M1219333 <P>Hi&nbsp;<SPAN>&nbsp;E</SPAN><SPAN class="UserName lia-user-name lia-user-rank-Contributor"><SPAN class="lia-link-navigation lia-page-link lia-link-disabled lia-user-name-link"><SPAN class="">jriri,</SPAN></SPAN></SPAN></P> <P>&nbsp;</P> <P><SPAN class="UserName lia-user-name lia-user-rank-Contributor"><SPAN class="lia-link-navigation lia-page-link lia-link-disabled lia-user-name-link"><SPAN class="">In the future, it would be a big help if you would attach a sample QVW. That way anyone&nbsp; who tries to help can try their solution out.&nbsp;</SPAN></SPAN></SPAN></P> <P>&nbsp;</P> <P><SPAN class="UserName lia-user-name lia-user-rank-Contributor"><SPAN class="lia-link-navigation lia-page-link lia-link-disabled lia-user-name-link"><SPAN class="">Bill</SPAN></SPAN></SPAN></P> <DIV id="messageEditor_6f845b4df6551_0" class="MessageEditor"><A id="previewButton_6f845b4df6551_51e8c" class="lia-link-navigation lia-message-editor-preview-button" href="https://community.qlik.com/t5/QlikView-App-Dev/Bar-Chart/td-p/1940798#" target="_blank">PREVIEW</A> <DIV class="lia-js-block-events"> <DIV class="lia-form-row lia-form-body-entry"> <DIV class="lia-quilt-row lia-quilt-row-standard"> <DIV class="lia-quilt-column lia-quilt-column-24 lia-quilt-column-single"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-single"> <DIV class="lia-form-input-wrapper"> <DIV id="rich_6f845b4df6551_51e8c" class="message-body-editor lia-inline-message-body-editor"> <DIV id="mceu_91" class="mce-tinymce mce-container mce-panel lia-editor-gte-2" tabindex="-1" role="application"> <DIV id="mceu_91-body" class="mce-container-body mce-stack-layout"> <DIV id="mceu_92" class="mce-top-part mce-container mce-stack-layout-item mce-first"> <DIV id="mceu_92-body" class="mce-container-body"> <DIV id="mceu_93" class="mce-toolbar-grp mce-container mce-panel mce-first mce-last" tabindex="-1" role="group"> <DIV id="mceu_93-body" class="mce-container-body mce-stack-layout"> <DIV id="mceu_94" class="mce-container mce-toolbar mce-stack-layout-item mce-first" role="toolbar"> <DIV id="mceu_94-body" class="mce-container-body mce-flow-layout"> <DIV id="mceu_95" class="mce-container mce-flow-layout-item mce-first mce-last mce-btn-group" role="group"> <DIV id="mceu_95-body"> <DIV id="mceu_53" class="mce-widget mce-btn mce-btn-small lia-mce-toolbar-bold" tabindex="-1" role="button" aria-pressed="false" aria-label="Bold">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Wed, 08 Jun 2022 11:38:19 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1940963#M1219333 Bill_Britt 2022-06-08T11:38:19Z https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1941312#M1219344 <P>thank you.<span class="lia-unicode-emoji" title=":grinning_face:">😀</span></P> Wed, 08 Jun 2022 23:15:13 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1941312#M1219344 ejriri 2022-06-08T23:15:13Z https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1941313#M1219345 <P>okay. Thanks</P> Wed, 08 Jun 2022 23:15:31 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/1941313#M1219345 ejriri 2022-06-08T23:15:31Z