Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
I have a attached a demo link of supply chain -Product Availability which is found on qlik sense website. Can Anyone help me out how to calculate that "Item Short n Store short " calcualations.
If any having that qvf please forward it.
Link:
Item Shot:
Count(DISTINCT {$<[Key_Item_Store]={"=(((Sum([Store On Hand Units])+sum([Store In Transit Units]))-
(4*Sum([EPOS Qty])/Count(DISTINCT [Date]))) <= 0)"}>} [Item])
Store Short:
Count(DISTINCT {$<[Key_Item_Store]={"=(((Sum([Store On Hand Units])+sum([Store In Transit Units]))-(4*Sum([EPOS Qty])/Count(DISTINCT [Date]))) <= 0)"}>} [Store])
You can see the expressions by duplicating the shhet. You can do that once you login
Item Shot:
Count(DISTINCT {$<[Key_Item_Store]={"=(((Sum([Store On Hand Units])+sum([Store In Transit Units]))-
(4*Sum([EPOS Qty])/Count(DISTINCT [Date]))) <= 0)"}>} [Item])
Store Short:
Count(DISTINCT {$<[Key_Item_Store]={"=(((Sum([Store On Hand Units])+sum([Store In Transit Units]))-(4*Sum([EPOS Qty])/Count(DISTINCT [Date]))) <= 0)"}>} [Store])
You can see the expressions by duplicating the shhet. You can do that once you login
Thanks for the answer. Can you just tell me what would be the "Key item Store" in general. In m y Inventory DB table i could not find the value that corresponds the "key_item_store".
Its not feasible , but just check in the below table column names. And tell what could be the key_item_store. Column names are business name and it is according to our convention.
`ID_ITM`, `ID_BSN_UN`, `ID_LCN`, `ID_ST_INV`, `ID_CTR_RVN_CST`, `ID_PRD_RP`, `ID_PRD_RP_CLD`, `DC_INV_FS_RCPT`, `DC_INV_LS_RCPT`, `MO_UN_RTL`, `MO_UN_CST`, `QU_ON_ORD_CNT`, `MO_ON_ORD_CST`, `MO_ON_ORD_RTL_AMT`, `QU_INTRST_CNT`, `MO_INTRST_CST`, `MO_INTRST_RTL`, `CD_MKD_CYCL`, `QU_DSC_ITM`, `QU_BGN`, `QU_RCV`, `QU_TSF_IN`, `QU_TSF_OT`, `QU_ADJT`, `QU_RTN`, `QU_SLS`, `QU_RTV`, `QU_END`, `CP_UN_AV_WT_BGN`, `CP_UN_AV_WT_END`, `TC_RCV_CM`, `TP_RCV`, `MO_VL_BGN`, `MO_MKN_CM`, `PE_MKN_CM`, `TP_SLS_GS_CM`, `TP_RTN`, `MO_TSF_IN_CM`, `MO_TSF_OT_CM`,
`TP_RTN_TO_VN`, `MO_ADJT_RT_CM`, `MO_MKD_PRN_CM`, `MO_MKD_TMP_CM`, `MO_MKP_PRN_CM`, `MO_MKP_TMP_CM`, `MO_DSC_EM_CM`, `MO_DPC_DM_CM_ITM`,
`MO_DPC_OT_OF_DT`, `MO_VL_END`, `QU_PHY_END`