Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Remove Duplicate values

I have duplicate values in my table, and I am trying to remove them, I have used Distinct load on both the table and the Generic Load Table.  Distinct Values 2.gif

Tags (3)
1 Solution

Accepted Solutions
joshabbott
Contributor III

Re: Remove Duplicate values

Try trimming your field.  It looks like this is a list box, so the 'Field' under 'General' could be an '<Expression>' that equals =Trim(YourFieldName) or better then that, if this is the issue, you could trim it in the script so all of your data is trimmed

View solution in original post

3 Replies
MVP
MVP

Re: Remove Duplicate values

better if you can post your qlik doc

joshabbott
Contributor III

Re: Remove Duplicate values

Try trimming your field.  It looks like this is a list box, so the 'Field' under 'General' could be an '<Expression>' that equals =Trim(YourFieldName) or better then that, if this is the issue, you could trim it in the script so all of your data is trimmed

View solution in original post

Not applicable

Re: Remove Duplicate values

Thank You!