I would like to have your input on a challenge I'm facing. Normally what if analysis as shown by Qlik is just about scaling a measure. This is about "moving" values in the data like using addmonths() in the script answering what if we produce this order 1 month earlier and another 2 months later?
The users uses Qlik Sense today to look at current production planning and material demand.
Now they want to be able to move the individual projects in time, that is left and right on the x-axis in the chart below. Like Addmonths(startdate,offset) in the script but they want to be able to do this without having to wait for a scheduled task to reload the application. Also each user should see the original data all the time in the application not being influenced by some other user moving a project 3 months in time.
Any user who added an offset to a project shall be able to store that offset and retrieve it next time.
I've been thinking about
- on demand app generation (ODAG)
- extensions which modifies the underlying data-set so all charts are updated in a session
- mashups with crossfilter and own charts.
I attached a simple qvf to show how it could look like.
My knowledge of Qlik Sense is rather limited, but ODAG basically re-runs the dashboard, so I am not sure if that serves the purpose. But If you have limited number of projects, can you not use a variable offset for each of the project and adjust the timeline based on the user input. For instance they can enter -2 for Project C, if they want to adjust it to be starting 2 months earlier or 2 if they want to adjust it to be starting 2 months later