2 Replies Latest reply: Aug 11, 2016 1:56 AM by Deepak K M RSS

    Calculation for the In Short Items

    Deepak K M

      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-9e3d-3c80a27cfbf8/state/analysis

        • Re: Calculation for the In Short Items
          Phaneendra Kunche

          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

            • Re: Calculation for the In Short Items
              Deepak K M

              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`