topic Re: Time interval in bar chart in QlikView

Time interval in bar chart

Tue, 10 Nov 2015 06:38:07 GMT

Hello All,

I have an issue. I have to calculate the time taken by an agent on call, on stand by and on break for an interval of 30 mins.

Below is the graph of what I did:

However, I want the limit the chart to 30 minutes.For example if the agent take 15 mins break at 14:45 and end the breaks 15:15 so the graph shows Orange halfway at 14:30 and halfway Orange at 15:00.

Is it possible to do so?

Many thanks for your help.

Kind Regards,

Hasvine

Re: Time interval in bar chart

Anonymous — Tue, 10 Nov 2015 06:42:09 GMT

could you post the sample data??

Re: Time interval in bar chart

Kushal_Chawda — Tue, 10 Nov 2015 06:43:04 GMT

Can you post sample application?

Re: Time interval in bar chart

Anonymous — Tue, 10 Nov 2015 06:45:11 GMT

Also, if some body take break at 14:45 and it ends at 15:15 then it would be 30 mins break not 15 mins

Re: Time interval in bar chart

Tue, 10 Nov 2015 06:48:37 GMT

ya sorry my mistake..I will post the application shortly.

Thanks.

Re: Time interval in bar chart

Tue, 10 Nov 2015 06:58:39 GMT

Hi where do you go to attach the QVW?

Thanks,

Hasvine

Re: Time interval in bar chart

nagarjuna_kotha — Tue, 10 Nov 2015 07:03:49 GMT

Post the sample file.

Re: Time interval in bar chart

Anonymous — Tue, 10 Nov 2015 07:11:01 GMT

during Reply, see the option USE ADVANCE EDITOR ON THE TOP RIGHT

AND THEN TOP RIGHT BOTTOM TO ATTACH

Re: Time interval in bar chart

nagarjuna_kotha — Tue, 10 Nov 2015 07:23:05 GMT

Hi Hasvine,

what is the logic for Deviation. and also post sample data.

Reagrds,

Nagarjuna

Re: Time interval in bar chart

Tue, 10 Nov 2015 07:49:36 GMT

Hi, Attached the QVW.

Thanks,

Hasvine