Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if condition

Hi

i have the following data in Qlikview pivot. i have the data till cumulative column.

Item No.Document No.Receipt QtyCurrent StockROW No.()CumulativeStock
APur-1518155
APur-2141821913
BPur-320120

I want to calculate the transactions that form part of stock. for eg. For item A, the Total stock is 18, so 5 qty of Pur-1 and 13 Qty of Pur-2 are required for stock.

for item B, since stock is Zero, none of the Receipts should be considered.

Can anyone help in writing the expression that claculates the stock as given above.

please help.

0 Replies