Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gauravgg
New Contributor III

Distinct hours in list box

hi

when i removed hours form timestamp field

when i put hours in list box they are repeating in want only the distinct hours in the listbox

can anyone help me?

thanx in advance

Tags (1)
1 Reply
MVP
MVP

Re: Distinct hours in list box

Use

LOAD

      Hour(TimestampField) as HourField,

     ...

instead of (assumed) formatting using Date() or Time() function, like Time(TimeStampField, 'hh')