Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

deepak_km9886
New Contributor III

Calculation for the In Short Items

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:

https://sense-demo.qlik.com/sense/app/c5e3a72d-a14c-486c-bc95-3465e6ad4c1a/sheet/2412dbf5-5320-4a92-...

Tags (2)
1 Solution

Accepted Solutions
phaneendra_kunc
Valued Contributor III

Re: Calculation for the In Short Items

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

Qlik Sense

2 Replies
phaneendra_kunc
Valued Contributor III

Re: Calculation for the In Short Items

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

Qlik Sense

deepak_km9886
New Contributor III

Re: Calculation for the In Short Items

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`