topic Re: Chart Aggregation Function in QlikView

Chart Aggregation Function

Thu, 10 Oct 2013 08:17:26 GMT

Is any one have idea that how to calculate this in aggregation function.

Sum((Max(EndDate)-MAX(StartDate)))

This is not working in my Calculation and return nothing.

Thu, 10 Oct 2013 08:26:30 GMT

can you give sample data ? or screenshot

jagan — Thu, 10 Oct 2013 08:29:42 GMT

Hi,

Where you are using this expression, in chart? Can you provide some sample data, it is difficult to understand without data.

Regards,

Jagan.

Thu, 10 Oct 2013 08:35:03 GMT

Data attached.

Im using this in my chart .

And this is due to POSTTIME because as you see this is repeat most time and this is right.

But i want to calculate Duration between TRANSFER TO ITG and DATA RECEIVED DATE.

Gysbert_Wassenaar — Thu, 10 Oct 2013 08:36:23 GMT

Please don't create more than one discussion for the same question. See this discussion for an answer: Chart Aggregation Function

Thu, 10 Oct 2013 08:47:09 GMT

I didn't create the second one.

I think this was due to system error.