Referencing Monthly Status

[WBMcCarel]

Alright, so I've hit a snag. Trying to develop an app that will allow the brass to look at a month by month run down of how our orders are being handled.  This has me working on a few charts that I can not seem to get . The big one has the following columns:

Backorders (orders due prior to [Selected Month] but not shipped)  

Sales

Backorders at End of Month

Future_1  (Orders Due to be shipped in [Selected Month] +1, i.e. [SM] = Jan | F1 = Feb)

Future_2 (Orders Due to be shipped in [Selected Month] +2)

Having a whole yearly chart would be easy, but finding how to reference JUST the specific periods within a moving 4 month interval is driving me crazy.

My company already has something that does this by running everything in the script, it takes 3 hours to run. I've been tasked with getting that number down and improving functionality. I've got most of it done, but this is where I seem to have hit a wall. Unless I missed something Set Analysis will not let me do {<MonthIndex = {[SelectedMonth] +1}>}. So what can I do?

Thanks in advance.

[Stoyan_Terziev]

Hi WBMcCarel,

You CAN do {<MonthIndex = {[SelectedMonth] +1}>}

Here is how it should look like using working Set Expression:

=Max({1<MONTH={'$(=GetFieldSelections(MONTH)+1)'}>}MONTH)

[Brett_Bleess]

Did Stoyan's post help, if so, be sure you circle back and use the Accept as Solution button on his post to give him credit for the help and let other Members know that worked for you.

Here are some Design Blog posts that may give you some further ideas too, and the last one is the base URL to the area, so you can search yourself if you wish, there are hundreds of posts in this area that are mostly how-to related...

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett