This is about making life easier for you by making calculations on the GUI of a QlikView application easier to understand at any time (4 weeks after you made it, 1 year after ...) both for you and for anyone else who might have to deal with your applications.
Sometimes you have to do a complex calculation like the following:
- We have a delivery of 14 items (there is only one, so this is all we have to work on)
- A nr. of items (say, 10) is due at a specific date (DueDate1)
- A nr. of items (say, 5) is due at another date (say, DueDate2 is one week after DueDate1)
- A nr. of items (say, 5) is due at another date (say, DueDate3 is one week after DueDate2)
=> In week1 (runup to DueDate1, we have 14 items, so we can process the entire stock of orders (10)
=> We have 0 orders to carry over to week2
=> We have 4 items to carry over to week2
=> In week2, we have 5 new orders + 0 leftover_orders, but only 4 items left
=> We can only process 4
=> We have 1 order to carry over to week3
=> There are 0 items left to process in week3
=> In week3, we have 5 new orders + 5 leftover_orders, so that's 10 orders in total
=> We have 0 items left, so we can process 0
That makes for a tremendously complex calculation - if you want to do it all in one go.
There is, however, another way: Go about it in small steps like they do in school.
- In almost any kind of diagram (this will be a straight_table), you can refer to calculations that are further up in the dialog
(calculated first) just by naming them in a "later" calculation - you just use their result without repeating all the calculation
- In a straight_table, you can choose which columns to display and which to hide
=> Voila - combine the two possibilities and you see you can calculate both the leftover_orders and the leftover_material from every
week and put them in columns that you just don't display and you can still refer to them by just naming them in "later"
=> That makes the entire calculation much easier to understand.
If you want, you can write the prefix "aux" or sth. in the formula_name to show immediately that it is an auxiliary calculation and thus not displayed.
I attach a small sample Excel file and the corresponding .qvw to illustrate this.