https://community.qlik.com/t5/QlikView/quot-Your-data-is-not-Unique-quot-problem/m-p/1549244#M744733 Hi,<BR /><BR />"Actual Yield" its a key field, you need to create a copy of this field to use "Distinct" and can sum or count unique values<BR /><BR />Regards,<BR />ACC Tue, 26 Feb 2019 13:59:39 GMT andrescc 2019-02-26T13:59:39Z https://community.qlik.com/t5/QlikView/quot-Your-data-is-not-Unique-quot-problem/m-p/1549048#M744732 <P>May i know what thus this message means.</P><P>About the data:</P><P>Each ID will have 12 months Data and each ID consist a Fix Information every month</P><P>thus, I have separate excel for fix data and separate estate for variable data</P><P>I think it is not unique because in fix data I did not put the month but for variable data, I have the column 'month'</P><P>&nbsp;</P><P>2nd question, what does distinct mean actually</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="01.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6723iD27B5532214EEDC9/image-size/large?v=v2&amp;px=999" role="button" title="01.png" alt="01.png" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/quot-Your-data-is-not-Unique-quot-problem/m-p/1549048#M744732 iliaisyah 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/quot-Your-data-is-not-Unique-quot-problem/m-p/1549244#M744733 Hi,<BR /><BR />"Actual Yield" its a key field, you need to create a copy of this field to use "Distinct" and can sum or count unique values<BR /><BR />Regards,<BR />ACC Tue, 26 Feb 2019 13:59:39 GMT https://community.qlik.com/t5/QlikView/quot-Your-data-is-not-Unique-quot-problem/m-p/1549244#M744733 andrescc 2019-02-26T13:59:39Z