topic convert to time format in QlikView

convert to time format

Wed, 16 Jul 2014 13:46:30 GMT

I have calculated the interval between all the times I have in emptyings_time;

emptyings_time is a time field.

The interval has small values, mostly a minute or 2.

This is my interval calculation:

=below(emptyings_time,1)-(emptyings_time)

In the pivot I selected time as format and that works perfectly, but now I want to use it in a chart.

Where I can't select the time format, so I have to change it another way.

Can anyone please help?

Re: convert to time format

Wed, 16 Jul 2014 13:57:32 GMT

can you attach sample file?

Re: convert to time format

ashfaq_haseeb — Wed, 16 Jul 2014 14:00:07 GMT

Hi,

look at the attached document

Regards

ASHFAQ

Re: convert to time format

Thu, 17 Jul 2014 06:49:06 GMT

The interval is always 00:00:00 that isn't correct.

It should be 1 minute (most of the intervals)

Re: Re: convert to time format

Thu, 17 Jul 2014 07:51:38 GMT

I attached a qvw file with sample data.

Good luck!

Re: convert to time format

Thu, 17 Jul 2014 08:57:18 GMT

actually it will not work like this way, you need to add the interval on pre load, while reading the data you need to calculate this interval.

I will try to make it today for you. once I finish my work.

good luck.

Re: convert to time format

Thu, 17 Jul 2014 09:01:14 GMT

That would be great, thank you!

I'm still pretty new to qlikview, so I look forward to see how it is done correctly

Re: Re: convert to time format

ashfaq_haseeb — Thu, 17 Jul 2014 11:24:55 GMT

Hi,

Look at the attached document.

Regards

ASHFAQ

Re: convert to time format

Thu, 17 Jul 2014 12:31:31 GMT

This is it.... ashfaq_haseeb you did it.

Re: convert to time format

Fri, 18 Jul 2014 07:27:24 GMT

Looks great!

How do I get these time intervals in a graph?

With on the horizontal axes the hours of a day

on the vertical axes the intervals, and as expression also the intervals.