Duplicate timestamp values tying to specific dates

nrq — Thu, 13 May 2021 04:26:22 GMT

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.

Re: Duplicate timestamp values tying to specific dates

tresB — Thu, 13 May 2021 05:03:40 GMT

Try like:

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

Re: Duplicate timestamp values tying to specific dates

nrq — Thu, 13 May 2021 13:39:50 GMT

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

topic Re: Duplicate timestamp values tying to specific dates in QlikView

Duplicate timestamp values tying to specific dates

Re: Duplicate timestamp values tying to specific dates

Re: Duplicate timestamp values tying to specific dates