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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Writing Expression

Hi

I need help writing an expression out of the logic below.

=SUM(Jan-Y,current year)FieldName

where Y = any Month selected

current Year = Year selected

Labels (1)
1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

Check with this

Sum({<Month=,Year=,DateField={">=$(=YearStart(Max(DateField)))<=$(=MonthEnd(Max(DateField)))"}>} FieldName)