Skip to main content

Qlik

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
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

258 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

118 Views
0 Likes