Sum of Month Range in KPI Box

[AsifAKhan]

Hi,

Would like to do a sum based on Date start from fiscal year start month and till date, the Fields are like below.

Date, Total

Looking for something like below.

=Sum({<'>=Date(Yearstart(Max([Date]),0,4),'MMM-YY')<=Date(Max([Date]),'MMM-YY')}>,Total)

Thanks in Advance 🙂

[Dalton_Ruer]

What you will need to use is called Set Analysis. 

I have attached a workshop I wrote for it that will give you more information than you ever wanted to know so that you understand what Set Analysis is within Qlik. 

This Community Post has pretty much exactly what you are looking for regarding a date range. https://community.qlik.com/t5/QlikView-App-Dev/Date-range-in-set-analysis/m-p/965088