Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All, we have requirement to calculate the shortage of a raw material which is been used across multiple orders.
Quantity has to be deducted from total quantity when the required quantity is posted.
For eg.,
Qlikview current values:
Expected Values :
Net Required Quanity | Release Materials | Shortage quantity |
208.8 | 104 | -104.8 |
208.8 | -104.8 | -313.6 |
208.8 | -313.6 | -522.4 |
Appreciate all your inputs on this.
there is no difference, but the reqd qty should be the previous value from shortage
and the first value of required qty comes from a field UB01 in the QVW.
Would you be able to highlight this in the qvw file? I am still not sure I am able to understand this
Net Required Quanity | Release Materials | Shortage quantity |
| field (IOUB01) | -104.8 (calc field) |
| -104.8 (previous shortage value) | -313.6 |
| -313.6 (previous shortage value_ | -522.4 |
Try this for Released Materials
if(column(5) < 0, Alt(Above(TOTAL sum({<IOLOTS = {' ','G','W'}>}IOUB01/1000000) - Rangesum(Above(TOTAL sum(WMUORG/1000000) - sum(WMTRQT/1000000),0,NoOfRows(TOTAL)))), sum({<IOLOTS = {' ','G','W'}>}IOUB01/1000000)), 'No short')
please see the release materials in the snapshot and the QVW file i shared, they are different.