Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
iliaisyah
Contributor III
Contributor III

"Your data is not Unique" problem

May i know what thus this message means.

About the data:

Each ID will have 12 months Data and each ID consist a Fix Information every month

thus, I have separate excel for fix data and separate estate for variable data

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'

 

2nd question, what does distinct mean actually

01.png

1 Reply
andrescc
Contributor III
Contributor III

Hi,

"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

Regards,
ACC