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.
