Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

if condition


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

Item No.Document No.Receipt QtyCurrent StockROW No.()CumulativeStock

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.