Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jpjust
Specialist
Specialist

SUM for each month

Hi,

I have an qliksense table as below.

I want the new field Total Month to be calculated as below. Is it possible using any expression? Thanks

MonthDate                   Day                   Amount               Total Month

April                               01                          500                        2000

April                               02                         1500                      2000

May                                01                          2000                      4500

May                               02                           2500                     4500

1 Solution

Accepted Solutions
eike_s
Partner - Contributor III
Partner - Contributor III

Just use Sum(Total<MonthDate> Amount) for your Total Month expression

View solution in original post

5 Replies
eike_s
Partner - Contributor III
Partner - Contributor III

Just use Sum(Total<MonthDate> Amount) for your Total Month expression

jpjust
Specialist
Specialist
Author

Thanks.

It presents me with an wrong value.

jpjust_0-1636125596362.png

 

jpjust
Specialist
Specialist
Author

Sorry, I validated the data wrongly. Actually it worked.

Thanks much for your help.

jpjust
Specialist
Specialist
Author

Hi Max, Thanks for the resources, I will go over it.