topic Distinct hours in list box in App Development https://community.qlik.com/t5/App-Development/Distinct-hours-in-list-box/m-p/1052709#M16607 <HTML><HEAD></HEAD><BODY><P>hi</P><P>when i removed hours form timestamp field</P><P></P><P>when i put hours in list box they are repeating in want only the distinct hours in the listbox</P><P></P><P></P><P>can anyone help me?</P><P></P><P></P><P>thanx in advance</P></BODY></HTML> Fri, 11 Mar 2016 05:44:45 GMT gauravgg 2016-03-11T05:44:45Z Distinct hours in list box https://community.qlik.com/t5/App-Development/Distinct-hours-in-list-box/m-p/1052709#M16607 <HTML><HEAD></HEAD><BODY><P>hi</P><P>when i removed hours form timestamp field</P><P></P><P>when i put hours in list box they are repeating in want only the distinct hours in the listbox</P><P></P><P></P><P>can anyone help me?</P><P></P><P></P><P>thanx in advance</P></BODY></HTML> Fri, 11 Mar 2016 05:44:45 GMT https://community.qlik.com/t5/App-Development/Distinct-hours-in-list-box/m-p/1052709#M16607 gauravgg 2016-03-11T05:44:45Z Re: Distinct hours in list box https://community.qlik.com/t5/App-Development/Distinct-hours-in-list-box/m-p/1052710#M16608 <HTML><HEAD></HEAD><BODY><P>Use</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; <STRONG>&nbsp; Hour(TimestampField)</STRONG> as HourField,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>instead of (assumed) formatting using Date() or Time() function, like Time(TimeStampField, 'hh')</P></BODY></HTML> Fri, 11 Mar 2016 21:54:33 GMT https://community.qlik.com/t5/App-Development/Distinct-hours-in-list-box/m-p/1052710#M16608 swuehl 2016-03-11T21:54:33Z