Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
can you attach sample file?
Hi,
look at the attached document
Regards
ASHFAQ
The interval is always 00:00:00 that isn't correct.
It should be 1 minute (most of the intervals)
I attached a qvw file with sample data.
Good luck!
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.
That would be great, thank you!
I'm still pretty new to qlikview, so I look forward to see how it is done correctly
Hi,
Look at the attached document.
Regards
ASHFAQ
This is it.... ashfaq_haseeb you did it.
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.