I have raw table1 as below. ITEM_No is product identity; Qty is the need for each STO; Stocks is the same for each product.
Below Table2 is the result i want to get. For each distinct article, when the Stocks_Remaining below zero, i wish to have a comment as "N" and before the Stocks_Remaining reach zero, i wish to have a comment as "Y" for these stores.
Attached are an QVW file incudling the raw data and an excel file that shows how we do it in excel.
I have no idea how to get this result table through Qlikview. Could someone help here in QLIKVIEW?