calculation of a value in a column depending on the sum of older entries
I would like to have an Diagramm where I can see the packing date and packing time on the x Axis and the "total weight so far" on the y axis.
I do not have re results of the column "total weight so far" and have to calucalte them. The value the "total weight so far" is always the sum of the order weight where the "packing time" is less than the current packing time of the packing date.
0 (time at last finished data load) 1 (time at function call) 2 (time when the app was opened)
From my initial test app, it did not work as I expected. It looks like Qlik is caching the information and not reloading as I expected. I will attached the example app so that others can help tweak it.
Re: calculation of a value in a column depending on the sum of older entries
I added David's recommendation to the load script as well as added it to the example table in the application. I am not sure I understand your business case so it is difficult to assist much further. Specifically, how are you deriving the weight so far (sql query)? Perhaps you could revise your data table with an actual date time and example formulas. If you are hoping to make this dynamic you will have to perform those calculation in the application or your data will need to be refreshed constantly through the load script. Also, how often does the underlying data change. For example, how often to pending order turn to completed and fall off the chart? When you had weight variable you really meant wait (as in measure of time), correct? Good luck!