Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Chart Aggregation Function

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.

2 Replies
MVP
MVP

Re: Chart Aggregation Function

Hi,

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

Regards,

Jagan.

Re: Chart Aggregation Function

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,


talk is cheap, supply exceeds demand
Community Browser