Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
WBMcCarel
Contributor
Contributor

Referencing Monthly Status

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.

 

Labels (3)
2 Replies
Stoyan_Terziev
Partner
Partner

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)

 

image.png

 

 

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.