Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
braham
Creator
Creator

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
Creator
Creator
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
Creator
Creator
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

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)