https://community.qlik.com/t5/QlikView/Expression-Total/m-p/1781141#M1209467 <P>Hi,&nbsp;</P><P>I have 4 dimension and expression in pivot table. Now I want the total for zone wise and Using&nbsp; Distinct in expression. Now if I am using Distinct Value in Expression then it is giving wrong value in expression.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sona_sa_0-1612864761593.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48721iC387A9296C98D146/image-size/medium?v=v2&amp;px=400" role="button" title="sona_sa_0-1612864761593.png" alt="sona_sa_0-1612864761593.png" /></span></P><P>My Output should be - 140 but it is giving 118. But I want to use Distinct in my expression.</P><P>Expression = Sum of Target.</P><P>Can anyone help me on this.</P><P>Regards,</P><P>AS</P> Tue, 09 Feb 2021 10:01:49 GMT sona_sa 2021-02-09T10:01:49Z https://community.qlik.com/t5/QlikView/Expression-Total/m-p/1781141#M1209467 <P>Hi,&nbsp;</P><P>I have 4 dimension and expression in pivot table. Now I want the total for zone wise and Using&nbsp; Distinct in expression. Now if I am using Distinct Value in Expression then it is giving wrong value in expression.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sona_sa_0-1612864761593.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48721iC387A9296C98D146/image-size/medium?v=v2&amp;px=400" role="button" title="sona_sa_0-1612864761593.png" alt="sona_sa_0-1612864761593.png" /></span></P><P>My Output should be - 140 but it is giving 118. But I want to use Distinct in my expression.</P><P>Expression = Sum of Target.</P><P>Can anyone help me on this.</P><P>Regards,</P><P>AS</P> Tue, 09 Feb 2021 10:01:49 GMT https://community.qlik.com/t5/QlikView/Expression-Total/m-p/1781141#M1209467 sona_sa 2021-02-09T10:01:49Z https://community.qlik.com/t5/QlikView/Expression-Total/m-p/1781290#M1209476 <P>this just means that whatever field you are counting distinct of is shared across Location at the least which means 118 is correct.&nbsp; if the field you are counting in one location is not the same for the same value in another location then maybe you can do a distinct of location + FIELD and not just distinct of FIELD<BR /><BR />if this does not help, you may need to give more info</P> Tue, 09 Feb 2021 15:42:35 GMT https://community.qlik.com/t5/QlikView/Expression-Total/m-p/1781290#M1209476 edwin 2021-02-09T15:42:35Z