Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Khan
Creator III
Creator III

How to sum the Data of Dynamic months

I wanted to sum the value of dynamic months.By default it should calculate the values starting from Aug till any selected month

I am trying to implement the same through below expression but unable to do so

=sum({<Year={$(vCurrentYear)},Month={">= $(vFiscalYearStartMonth) <= $(vMaxMonth)"}>}[Net Bookings])

Bcoz my YTD is calculating on month Basis.Which includes sum of the months from first month of the Fiscal year i.e August till my selected month.

Regards,

KK

KK
0 Replies