Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Distinct values

Hello Community members,

I have a colum in my straight table in which the values are repeating , how to avoid the duplicate values. Can anyone please suggest me

Regards,

Ramesh

2 Replies
MEllinghausen
Creator III
Creator III

in script:

sort by colum and load * where previous(colum)<>colum;

Marcus

Gysbert_Wassenaar

If they are repeating then the records are not unique. This can happen when for example you format a date as a month. The underlying date values are still dates, but the display format is month. That's when you see repeating month values because the actual values are still distinct dates. Check if that's the case in your document. You may have to create extra fields in the script, for example month(MyDate) as Month instead of date(MyDate, 'MMM') as Month. The latter only changes the display format, the former creates a new Month field with distinct month values.


talk is cheap, supply exceeds demand