Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikwiz123
Contributor

Sum and Aggregate on two fields

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.

 

Labels (3)
1 Solution

Accepted Solutions
segador_
New Contributor III

Re: Sum and Aggregate on two fields

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)

Regards, Igor.
2 Replies
segador_
New Contributor III

Re: Sum and Aggregate on two fields

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)

Regards, Igor.
qlikwiz123
Contributor

Re: Sum and Aggregate on two fields

@segador_  Perfect. Thanks