https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2142613#M1224897 <P>Yes, you understood correctly, I want to 7.02% shown in the graph</P> Thu, 30 Nov 2023 03:45:16 GMT Paknanarn23 2023-11-30T03:45:16Z https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2141359#M1224882 <P>I want to put the Total %Scrap value on the graph.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_0-1701057687580.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/120605iBB0012F30FAF105F/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_0-1701057687580.png" alt="Paknanarn23_0-1701057687580.png" /></span></P> <P>The conditions will be WorkCenter = MIC,TCC,TCL,TCE,DES.</P> <P>This is the code used to calculate %Scrap.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_1-1701057780576.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/120606i56A382F32DB5B5C0/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_1-1701057780576.png" alt="Paknanarn23_1-1701057780576.png" /></span></P> <P>What should I do? please help me</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 27 Nov 2023 04:04:01 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2141359#M1224882 Paknanarn23 2023-11-27T04:04:01Z https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2142533#M1224896 <P>Do I understand clearly that you want the whole column %Scrap to be filled with the value 7.02% ?</P> Wed, 29 Nov 2023 17:08:10 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2142533#M1224896 tabletuner 2023-11-29T17:08:10Z https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2142613#M1224897 <P>Yes, you understood correctly, I want to 7.02% shown in the graph</P> Thu, 30 Nov 2023 03:45:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2142613#M1224897 Paknanarn23 2023-11-30T03:45:16Z https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2142680#M1224899 <P>Note the addition of the TOTAL statement.&nbsp;</P> <P>=Sum(<STRONG>TOTAL</STRONG> {&lt;Plant, etc&gt;}/<BR />if(GetFieldSelections(WorkCore)='INNER',<BR />Sum(<STRONG>TOTAL</STRONG> {&lt;WorkCore_SSD='INNER'},etc<BR />Sum(<STRONG>TOTAL</STRONG> {&lt;WorkCore_SSD='OUTER'},etc</P> <P>Would this solve the problem?</P> Thu, 30 Nov 2023 07:48:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2142680#M1224899 tabletuner 2023-11-30T07:48:30Z https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2144534#M1224945 <P>Hi, did my answer help you? Please mark as solved then <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 05 Dec 2023 20:00:02 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-value-In-the-table-put-a-bar-graph/m-p/2144534#M1224945 tabletuner 2023-12-05T20:00:02Z