convert to time format

[#1]

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?

[#2]

can you attach sample file?

[ashfaq_haseeb]

Hi,

look at the attached document

Regards

ASHFAQ

[#4]

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

It should be 1 minute (most of the intervals)

[#5]

I attached a qvw file with sample data.

Good luck!

[#6]

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.

[#7]

That would be great, thank you!

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

[ashfaq_haseeb]

Hi,

Look at the attached document.

Regards

ASHFAQ

[#9]

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

[#10]

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.