Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshm030
Creator III
Creator III

How to get DISTINCT values in a single field?

Hi,

I have lot of duplicate values in a single field. I don,t want duplicate values.

Ex:

Field Name:

aa,

bb,

aa,

cc,

dd,

dd,

xx

Output:

aa,

bb,

cc,

dd,

xx

Regards,

Dinesh Kumar M.

6 Replies
sunny_talwar

Do you have other fields in this table where the value is not the same? for instance;

FieldName, FieldName2

aa, 1

aa, 2

If this is the case, how do you want to handle this? Sum(FieldName2) or an aggregation like that? If this is the only field, then you can use DISTINCT keyword after your load statement

LOAD DISTINCT FieldName

FROM....

dineshm030
Creator III
Creator III
Author

Hi Sunny,

I want to write DISTINCT syntax in expression not in script without any arithmetic operation like count,sum,etc

Regards,

Dinesh Kumar M

Anonymous
Not applicable

just add  DISTINCT key field before the filed name 

Anil_Babu_Samineni

Why duplicates showing, if you have only one list box then Qlikview default removes the duplicates. I think you might clear this

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

Where exactly are you using this as an expression?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In what object or chart are you writing the expression?

-Rob