Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

adoteykwame
Contributor

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

1 Reply

Re: Writing Expression

Check with this

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

Community Browser