Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Gerald, you can use Interval() function instead of Time()
Hi Gerald, you can use Interval() function instead of Time()
Thanks Ruben.
Hi Ruben,
Is my string sequence correct or does the Average function be in-front of Interval function?
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
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.