Time chart with Sum

jindrichk — Tue, 07 May 2013 07:14:07 GMT

Hello,

I have this table:

SOURCETABLE:

LOAD * INLINE [

ItemName, MinutePrice, StartDateTime, StopDateTime

'Item1', 5, '10/18/2013 12:00', '10/18/2013 18:00'

'Item2', 2, '10/18/2013 05:25', '10/18/2013 14:30',

'Item3', 13, '10/18/2013 17:15', '10/18/2013 22:00',

'Item4', 1, '10/17/2013 12:00', '10/19/2013 12:00',

'Item5', 22, '10/18/2013 10:00', '10/18/2013 16:45',

];

And I would like to create a graph which will have Time on X axis and Price on Y axis. The Time period on X should be selectable. It should show the summarize of the prices of all items which are done on each minute.

Lets take time 10/18/2013 17:00. We can see that in this minute there are Item1, Item3 and Item4. So the graph should show numer 19.

Can anybody help me create the logic for such a graph? Is it even posible? I was thinking about some VB script or something like this but can't figure it out right now.

Thanks,

Jindra

Re: Time chart with Sum

Anonymous — Tue, 07 May 2013 08:41:04 GMT

Hi Jindra,

You can do this using IntervalMatch().

Take a look at the F1-helpfile for usage examples or search the forums.

topic Re: Time chart with Sum in QlikView

Time chart with Sum

Re: Time chart with Sum