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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-07-05 07:05 AM

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

329 Views
0 Likes
1 Reply
Miguel_Angel_Baeyens
Employee
Employee
‎2010-07-05 07:20 AM

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

189 Views
0 Likes