Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

MVP
MVP

Re: Calculating last 6 months based on selected month

Hi,

Try this expression

=Sum({<Month={'>=$(=Max(Month) - 5)<=$(=Max(Month))'}>}Amount)


Regards,

Jagan.

Highlighted
ecolomer
Honored Contributor II

Re: Calculating last 6 months based on selected month

if you need include selected month use this:

=Sum({<Month={'>=$(=Max(Month) - 5)<=$(=Max(Month))'}>}Amount)


p-roll.png

Not applicable

Re: Calculating last 6 months based on selected month

Helpful. Thanks.

Not applicable

Re: Calculating last 6 months based on selected month

Hi Jonathan,

Actually my real dates are in DD/MM/YYYY so do I need to seperate the Year?

Thanks,

Hasvine

Community Browser