Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregation Function in charts

Can we use aggregation function once we have while making charts and tables.

E.g. I want to aggregate data with respect to month. but don't want to include month as dimension.

Regards

1 Reply
Not applicable
Author

Not 100% sure I understand exactly what you want but here are some examples of what you can do.

Set analysis:

=sum({$<[Month]={'January'}>}[Sales])

=sum({$<[Month]={'February'}>}[Sales])

etc.

aggr Function:

Let's say you want to sum the invoices for customers that have been with the company less than 180 days (let's also assume you don't have a [Length with Company] field or anything like that) but you only want to show the dimension [City].  You could use the following expression:

=sum

)

     aggr

     (

          if(today()-[Join Date]<180,

                    sum([Invoice Total])

          )

     ,[Account Number]

     )

)

In the above example you can't use set analysis because the [Join Date] of every customer is going to be different and the set analysis is calculated once per chart, not once per row.  Also use the dimension [City] for the example above.  You're quesiton was pretty vague but hopefully that helped a little bit.