https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785814#M1210036 <P>can you try with sum of rows option?&nbsp; still same issue?</P> Wed, 24 Feb 2021 14:22:37 GMT Chanty4u 2021-02-24T14:22:37Z https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785748#M1210030 <P>Hello All,</P><P>I am facing issue with Total Mode Sum and Expression Total .If i am selecting Sum as a total mode its giving proper count if i am trying to change it to Expression total value returning 1</P><P>count(DISTINCT aggr(if(AGGR(if(min(DRAWING_REVISION_Number)='','',if(min(TOTAL&lt;Test&gt; DRAWING_REVISION_Number) and min(DRAWING_REVISION_Number)=1,<BR />'1',if(min(TOTAL&lt;Test&gt; DRAWING_REVISION_Number)=min(DRAWING_REVISION_Number),-1,min(DRAWING_REVISION_Number)))),DRAWING_REVISION_Number,Test)<BR />&gt;1,COUNT(DISTINCT Test)),DRAWING_REVISION_Number, Test))</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="agastya_0-1614166545548.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49768i4C7620E07C83D458/image-size/medium?v=v2&amp;px=400" role="button" title="agastya_0-1614166545548.png" alt="agastya_0-1614166545548.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="agastya_1-1614166574111.png" style="width: 106px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49769i5ADD2ED522120D76/image-size/small?v=v2&amp;px=200" role="button" title="agastya_1-1614166574111.png" alt="agastya_1-1614166574111.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="agastya_2-1614166598277.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49770iCEB8F5E271BFC86E/image-size/medium?v=v2&amp;px=400" role="button" title="agastya_2-1614166598277.png" alt="agastya_2-1614166598277.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 24 Feb 2021 11:38:38 GMT https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785748#M1210030 agastya 2021-02-24T11:38:38Z https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785811#M1210034 <P>Are you using any synthetic dimension in your chart?</P> Wed, 24 Feb 2021 14:11:26 GMT https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785811#M1210034 Chanty4u 2021-02-24T14:11:26Z https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785813#M1210035 <P>No chanty&nbsp;</P> Wed, 24 Feb 2021 14:20:45 GMT https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785813#M1210035 agastya 2021-02-24T14:20:45Z https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785814#M1210036 <P>can you try with sum of rows option?&nbsp; still same issue?</P> Wed, 24 Feb 2021 14:22:37 GMT https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785814#M1210036 Chanty4u 2021-02-24T14:22:37Z https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785824#M1210038 <P>Sum of rows giving proper O/P as i shown in screenshot</P> Wed, 24 Feb 2021 14:34:27 GMT https://community.qlik.com/t5/QlikView/Total-mode-expression-total-return-1/m-p/1785824#M1210038 agastya 2021-02-24T14:34:27Z