Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Duplicate timestamp values tying to specific dates

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.

2 Replies

Try like:

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

Contributor II
Contributor II

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