Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have to develop the following App. We are an Agricultural firm.
It is a forward planning tool consisting of 1 Variable (Resources allocated)
1. We have Soil Analysis displaying in Hectares that need to be done before a certain time in a Year.
This is what I need to do:
Start: 5000 Hectares (Week43)
Resources: 500 Hectares per week.
I need to calculate when that Start Hectares will be done. In what week? The catch is that the recourses are not set in stone and that it should be changeable when we see we will not finish in the set time.
So:
In week 42 we sit on 5000 Hectares. With recourses at 500 Hectares/ Week we will be finished with the work by week 51 where we will have no Hectares remaining. Here's the catch they maybe want the work to be done in week 49 so they need to send more recourses so the 500 Hectares/ Week should therefor change.
I hop someone can help me with this.
Kind regards
Hi @WernerDC
First of all, thank you for the sample data, it helped!
Second, when you reply to a topic in the Qlik Community you can type an @ it allows you to pick-up the account name of the people assisting you in that particular topic, so we get a promptly notification when you reply to us.
I made some changes to your Excel file and created a prototype of the application, you did not clarify about sharing this data here, or do you want them by private e-mail. I do not know if you need to comply with security protocols at your end, please clarify!
These are some of the actions I had taken with your Excel file:
The application I wrote is still a little bit raw.
I am sending by email the QVF and Excel file, but I believe we should share them here in the topic; please clarify your preference.
Some screenshots:
Regards,
@WernerDC can you share a sample data and the expected output ?
Hi @WernerDC
Very interesting scripting challenge, before I proposed my ideas, would you be able to confirm clarify these assumptions:
With your current example, this formula tells you the time in weeks to run out of resources:
[Weeks Required] = [Target Hectares] / [Weekly Resource]
Am I in the right track? Would you add/share more ideas?
Thanks in advance
Hi Arnado, thanks for your insights.
Please attach your email so I can mail the Excel concept.
Hi Taoufiq
Please attach your email so I can mail the Excel concept.
Hi @WernerDC
First of all, thank you for the sample data, it helped!
Second, when you reply to a topic in the Qlik Community you can type an @ it allows you to pick-up the account name of the people assisting you in that particular topic, so we get a promptly notification when you reply to us.
I made some changes to your Excel file and created a prototype of the application, you did not clarify about sharing this data here, or do you want them by private e-mail. I do not know if you need to comply with security protocols at your end, please clarify!
These are some of the actions I had taken with your Excel file:
The application I wrote is still a little bit raw.
I am sending by email the QVF and Excel file, but I believe we should share them here in the topic; please clarify your preference.
Some screenshots:
Regards,