Discussion board where members can get started with Qlik Sense.
Hi Folks ...
I have a doubt about how to show the inventory,
coming to the point
i have a ledger table with me and i want to show Zero inventory days and i'm done with this
but now i to want show particular item should not be considered where that item is never sold in that region/
branch due to not available
lets say for instance item A, item B, item C.
where A is avail in Region1 and B is available in Region1 & 2, C is available in only Region3
Can we have a fragment of data and what do you want to see as a result?
Refer my thread, Thanks
ABC Analysis in Qlikview
and also check this,
Recipe for an ABC Analysis
ABC Analysis to set and remember classification at runtime
Hope this helps you.
lets say an item is zero for all the days in one region but it is in stock for other regions that item should be considered as item never in stock
below logic is implemented foy zero inventory days
//rangesum(qty,if(item_code=Peek('Item') AND brcode=Peek('brcode'), Peek('Stock'))) AS Stock
//if(item_code=Previous(item_code) and brcode=Previous(brcode),peek('cum_qty')+qty,qty) as cum_qty
where match(brcode,'002','003') and dt >='01-04-2016' and dt <='30-06-2016'
//Group by brcode,
order by brcode,item_code,dt
drop Table stk_temp;
load Distinct dt
where dt >='01-04-2016' and dt <='30-06-2016'
load Distinct brcode
load Distinct item_code
//where item_code='I69195', and dt >='01-04-2016' and dt <='30-06-2016'
where match(item_code,'I69195','I65538','I00197','I00303','I00319','I00157','I00158','I00186','I00187') and dt >='01-04-2016' and dt <='30-06-2016'
drop Table stk;
sum(qty) as qty
Group by brcode,
if(item_code=Previous(item_code) and brcode=Previous(brcode),peek('cum_qty')+qty,qty) as cum_qty
date(dt) as dt,
if(cum_qty=0,1,0) as zero_stock_flag
drop Table stock_temp;
loaded data for 91 days
item_code brcode zero_days
I00197 003 91
i00303 003 91
i65538 003 91
i69195 003 4
This is my script for Zerodays
and now with in this i should consider item which is Zero inventory all the days in Region A but this is avail in another Region B&C
for the item i loaded is
noof days 91
and for particular item it is showing Zero inventory=4 days
now another couple of items are loaded to check but few among them are zero all 91 days
store STOCK into 'D:\Sai\Ceo_Dashboard\Ceo_transformed_qvd\STOCK.qvd'