Sum and Aggregate on two fields

[qlikwiz123]

Hi,

I need to create a Column with Sum on Funds and aggregate it to two fields.

I need to create a 'Resultant Column' which is a Sum(Funds) aggregated on Date and Cat fields.

[segador_ · Accepted solution]

Hi

You can try TOTAL qualifier with discription of fields which you need to include in aggregation. The TOTAL qualifier may be followed by a list of one or more field names within angle brackets <YourField>. These field names should be a subset of the chart dimension variables.

For example:

SUM(TOTAL<[Giver],[Cat]> Funds)

[qlikwiz123]

@segador_  Perfect. Thanks