Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

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_
Partner - Contributor III
Partner - Contributor III

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.

View solution in original post

2 Replies
segador_
Partner - Contributor III
Partner - Contributor III

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
Creator III
Creator III
Author

@segador_  Perfect. Thanks