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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use sum in charts

Hi,

What does SUM(total <Month> sales) exactly mean??

I am using sum(sales)/SUM(total <Month> sales but not getting the desired output.

Kindly suggest??

Regards,

Rohit

1 Reply
Miguel_Angel_Baeyens

Hello Rohit,

The dimension between angular brackets will be taken into account for the aggregation expression, instead of the aggregation for all dimensions. In your example, the sum will add only for the Month dimension.

Hope that helps