Time calculation in "Show Title in Chart" box

[#1]

Hi,

I have inserted a formula in the "Show Title in Chart" box, and this should give me the time(hh:mm:ss) calculated.

In the Gauge chart I have created to indicate Max time for a query to be resolved, it does not show the answer correctly. what it does is to indicate it as  dd:mm:ss. it automatically divides the total hours by 24. how can I stop it from doing this and indicate the full 575 hours that it shows when I hover my mouse over the chart.

I have attached relevant qvw.

[rubenmarin · Accepted solution]

Hi Gerald, you can use Interval() function instead of Time()

[#3]

Thanks Ruben.

[#4]

Hi Ruben,

Is my string sequence correct or does the Average function be in-front of Interval function?

[rubenmarin]

Hi,I think your avg are correct, [Total Time] has a numeric value than is over 1 when it's more than 24 hours, problem was that using Time() funtion QV converts it in a existing clock time

[#6]

Thank you. I just had to confirm as another developer here has indicated to me that in qlikview, I always have to put the avg/sum function in front. Doing this gives a total different answer.