Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pfb93
Contributor II
Contributor II

Sum a amount until the current month

Hey everyone,

I am struggeling with a thing which i think is very basic. I got the following table:

 

AccountJanuaryFebruaryMarchDecemberAmountToToday
1200 €30 €50 €10 €280 €

 

Suppose the current month is march, then i want the last column (AmountToToday) to calculate the sum of january, february and march. The calculation should always display the sum of the months until the current month of the year.

 

Thanks!

1 Reply
MK9885
Master II
Master II

Maybe

Sum({ < Month = {"<=$(=num(Month))"}, Year,Month ,Year = {$(=Max(Year))}   >}  AmountToToday)