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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

distinct function?

what is work of  distinct  function?

whether it wont allow duplicate values are ?

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

In load or Select or aggregations, Distinct predicate discards duplicate values (of the specified fields)

Not applicable
Author

Distinct will return the distinct values.

For example, if you have a field with three values:

Field:

A

A

B

count(field) will return 3 because you have 3 values in field

count(distinct field) will return 2 because A will be counted as 1

Not applicable
Author

It will not allow duplicate values

fkeuroglian
Partner - Master
Partner - Master