topic Chart Aggregation Function in QlikView

Chart Aggregation Function

Thu, 10 Oct 2013 08:17:25 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.

jagan — Thu, 10 Oct 2013 08:30:40 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.

Gysbert_Wassenaar — Thu, 10 Oct 2013 08:33:53 GMT

If you nest aggregation functions like sum and max you need to use the aggr function:

sum(aggr(max(EndDate)-max(StartDat),Dim1,Dim2,...,DimN))

Replace Dim1,Dim2,...,DimN with the dimensions of your chart,