Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
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.