Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator II
Creator II

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
Partner

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
Partner

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

qlikwiz123
Creator II
Creator II
Author

@segador_  Perfect. Thanks