Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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