topic Re: Sum and Aggregate on two fields in QlikView

Sum and Aggregate on two fields

qlikwiz123 — Sat, 16 Nov 2024 03:34:12 GMT

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.

Re: Sum and Aggregate on two fields

segador_ — Wed, 15 May 2019 20:32:06 GMT

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)

Re: Sum and Aggregate on two fields

qlikwiz123 — Wed, 15 May 2019 20:40:25 GMT

@segador_ Perfect. Thanks