Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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:


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.



1 Reply
Honored Contributor II

Re: Sum a amount until the current month


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