Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
pfb93
New 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
Khan_Mohammed
Honored Contributor II

Re: Sum a amount until the current month

Maybe

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