topic Re: How to use &quot;Distinct&quot; to exclude duplicate values in QlikView https://community.qlik.com/t5/QlikView/How-to-use-quot-Distinct-quot-to-exclude-duplicate-values/m-p/74547#M12307 <HTML><HEAD></HEAD><BODY><P>Use the Year function: year(TimeFormat)</P><P>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 <EM>seem </EM>to be the same, but they are still different and therefore shown individually in the listbox.</P></BODY></HTML> Sat, 21 Apr 2018 16:37:28 GMT Gysbert_Wassenaar 2018-04-21T16:37:28Z How to use "Distinct" to exclude duplicate values https://community.qlik.com/t5/QlikView/How-to-use-quot-Distinct-quot-to-exclude-duplicate-values/m-p/74546#M12306 <HTML><HEAD></HEAD><BODY><P>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.</P><P><IMG __jive_id="200443" alt="TimeFormat.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200443_TimeFormat.JPG" style="height: auto;" /></P></BODY></HTML> Sat, 21 Apr 2018 04:23:38 GMT https://community.qlik.com/t5/QlikView/How-to-use-quot-Distinct-quot-to-exclude-duplicate-values/m-p/74546#M12306 srinivas91k 2018-04-21T04:23:38Z Re: How to use "Distinct" to exclude duplicate values https://community.qlik.com/t5/QlikView/How-to-use-quot-Distinct-quot-to-exclude-duplicate-values/m-p/74547#M12307 <HTML><HEAD></HEAD><BODY><P>Use the Year function: year(TimeFormat)</P><P>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 <EM>seem </EM>to be the same, but they are still different and therefore shown individually in the listbox.</P></BODY></HTML> Sat, 21 Apr 2018 16:37:28 GMT https://community.qlik.com/t5/QlikView/How-to-use-quot-Distinct-quot-to-exclude-duplicate-values/m-p/74547#M12307 Gysbert_Wassenaar 2018-04-21T16:37:28Z