topic Inventory Aging in QlikView

Inventory Aging

siva0606 — Wed, 27 Feb 2013 07:40:33 GMT

In inventory ageing report ,I am having two quantities -StockQty and ReceiptQty as expression.

My output should come based on the below condition,

for eg: If the StockQty is 1000, then the receiptQty have to be splitted in agewise as follows

0to30days-250,30to60days-500,60to90days-250,90to120days-0 and >120 days-0

But in my application receiptQty not coming within the range of StockQty,its exceeding.

Please suggest me the condition for satisfying the above criteria.

nilesh_gangurde — Sat, 30 Nov 2013 07:43:32 GMT

Hiii Siva,

Please share the logic of Inventory Aging which you developed in Qlikview.

-Nilesh

Sat, 30 Nov 2013 07:58:26 GMT

take at least two dimension in pivot,

and in which take one dimension which is made on this

0to30days,30to60days,60to90days,90to120days and >120 days.

now drag and drop this dimension on the top of the expression

then this field show column wise 0-30, 30-60 etc.

then in expression

write if(StockQty =1000, receiptQty)