topic Trailing by 6Mon in QlikView

Trailing by 6Mon

Thu, 12 Jun 2014 16:29:34 GMT

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.

Re: Trailing by 6Mon

PrashantSangle — Sat, 14 Jun 2014 09:54:19 GMT

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,

Re: Trailing by 6Mon

Mon, 16 Jun 2014 13:54:47 GMT

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.

Re: Trailing by 6Mon

ashfaq_haseeb — Mon, 16 Jun 2014 13:58:33 GMT

Hi, look at the below post.

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

Regards

ASHFAQ