topic Time based Calculation Visualisation issue in QlikView

Time based Calculation Visualisation issue

amars — Fri, 14 Sep 2012 04:06:37 GMT

Hi all,

We are working on a dashboard, where we try to find out the Average time Required to solve the Issues.

Now ideally an issue should be solved within minimum two consicutive working days, so that we will show the time taken for solving the issue in Hours:Min:Sec.

Now in a chart we are finding the amount of time taken, Divided by the total no of cases to find the average. And we format it as Time.

But for some cases the difference is going in few no of days, in which case when formating the expression as Time Format shows it as zero.

Please suggest any other alternative to handle such a situation.

Thanks in Advance.

Regards

Amar

Re: Time based Calculation Visualisation issue

Jason_Michaelides — Fri, 14 Sep 2012 08:50:56 GMT

Can you provide an example?

Re: Time based Calculation Visualisation issue

amars — Thu, 11 Oct 2012 09:58:03 GMT

Hi all,

Just to let you know , how I resolved the issue.

Now when you format a value as Time(Value), it is having a restriction of 24 hours if the value exceeds 24 hours. then it will show the value as Value - 24 Hours as HH:MM:SS (i.e if 30 Hours then it will show only 06:00:00).

Rather if you use Interval (Vlaue, 'HH:MM:SS') then the restriction of 24 hour will not be there and the Hour can take a value of whatever hours like 30:10:20 i.e. HH:MM:SS. That is if you use Interval to format a Time Vlaue then the restriction of 24 Hours can be suppressed.

Thanks. Hope this helps others.

Amar