Duplicate timestamp values tying to specific dates

[nrq]

I have a date field in my QV app with the format of: M/D/YYYY hh:mm:ss TT. I need to create a visualization with just the timestamp on one axis, completely disregarding the date, so I converted it in the backend using Timestamp(MyDateField,'hh:mm:ss') as MyTimestampField.

However, now I have an issue where there is multiple timestamps with the same value that are tying specifically to certain dates. For example, there are 100 MyTimestampField values of 01:00:00. If I select one of the values, it ties to a specific date. I need there to be one value of 01:00:00 that ties to all the dates.

Why is QlikView not grouping these duplicate timestamp values together automatically? Is there a solution to this that I'm missing? Thank you in advance.

[tresesco]

Try like:

Timestamp(Frac(MyDateField),'hh:mm:ss') as MyTimestampField.

[nrq]

Thank you for the reply. I have tried using Frac and the issue still occurs.