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.
This is the part I am not sure about. May be instead of assigning customized variable, may be we create generic variable say v1, v2, v3 so that we can always have them with the same value. Will need to play around with the idea to get it to a point where you understand it's limitations, but yet work to some degree of satisfaction.