Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

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

Highlighted
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