Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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