Trailing by 6Mon

[#1]

Hi All,

I want to display month trailing by 6 month in my Chart.

I am new to Qlik thus not very familiar with Qlik

I saw

http://community.qlik.com/thread/99838

http://community.qlik.com/thread/99575

But didnt understand.

please see attachment.

I am using Personal Edition.

[PrashantSangle]

Hi,

Can You explain little bit more.

what you want to show with attached file wrt Trailling 6 months.

The basic expression for calculating trailing 6 month is

Sum({<MonthField={">=$(=Month(AddMonths(MonthField,-6)))<$(=max(MonthField))"}>}CalculationsField)

In your attached file MonthField could be Month and CalculationsField could be availability

Regards,

[#3]

In a chart (Sun(Availability)) I want to show chart for 6 month trailing by 6 mon.
As currently I have selected month Aug so it should display Mar to Aug.

[ashfaq_haseeb]

Hi, look at the below post.

http://community.qlik.com/docs/DOC-4252#comment-13141

Regards

ASHFAQ