Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivas91k
Contributor
Contributor

How to use "Distinct" to exclude duplicate values

Distinct : How to use "Distinct" to exclude duplicate values from table field. please find the snap , field timeFormat having duplicates i want to display unique values from this.

TimeFormat.JPG

1 Reply
Gysbert_Wassenaar

Use the Year function: year(TimeFormat)

Merely formatting the function with Date(TimeFormat, 'YYYY') doesn't change the real value, only the formatting. That's why the values in the listbox seem to be the same, but they are still different and therefore shown individually in the listbox.


talk is cheap, supply exceeds demand