Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
braham
Contributor III
Contributor III

Format of time on line graph

Morning

I once again would like to get some assistance with a problem I am having in Qlikview (April 2020 sr2). I need to calculate the service level, which is the difference between a start datetime field and and an end datetime field. The results must be shown in days as once field and the number of hours, minutes and seconds in the other field. When presenting the results as a table I get the following:

EventsID Count Days HH:MM:SS 
353023100:06:17
353058101:06:04
3530731023:06:16
3530781023:26:09
3530891118:39:02
3531281016:07:09
3531291016:12:48
3531301217:59:42
353167100:01:20
353169100:08:32
353175100:44:11
353183100:41:24
353185100:14:26
353196100:32:52
35323211323:07:45
35323611323:38:31
35323811323:48:18
Total 17222:27:06

 

When manually checking the results I am comfortable that the results are correct. 

When representing the same data as a graph the time axis shows a range from 04:00:00:00 PM to 01:00:00 AM. When hovering the mouse over the datapoint, the correct time is shown, but that value does not match with what the corresponding value on the axis shows. 

In my calculation I have added a time format, and set my time format in the number properties.

 

 

 
 

 

 

Labels (3)
1 Solution

Accepted Solutions
braham
Contributor III
Contributor III
Author

Thanks Anil

I have not visited this during the holiday period. I have resolved the issue by defining my time dimension as a Interval property and not as a time property.

Regards

Braham

View solution in original post

3 Replies
Anil_Babu_Samineni

Will you be able to share some Qlikview file and explain where that is not working?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
braham
Contributor III
Contributor III
Author

Thanks Anil

I have not visited this during the holiday period. I have resolved the issue by defining my time dimension as a Interval property and not as a time property.

Regards

Braham

View solution in original post

Anil_Babu_Samineni

Great, Please close this thread by mark yourself as answer.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)