WHAT IS QLIK VIEW STATISTICS BOX

Qlik View statistics box is a compact way of showing numeric fields, We can use some aggregate functions in statistics box.

EBS QUERY TO FIND PRODUCT CATEGORY INFORMATION

SELECT F.ORGANIZATION_CODE,
               E.SEGMENT1 PRODUCT,
               C.SEGMENT1 CATEGORY,
               A.DESCRIPTION CATEGORY_DESC,
               D.CATEGORY_SET_NAME
  FROM MTL_CATEGORIES_TL    A,
       MTL_ITEM_CATEGORIES  B,
       MTL_CATEGORIES_B     C,
       MTL_CATEGORY_SETS_TL D,
       MTL_SYSTEM_ITEMS_B E,
       MTL_PARAMETERS F
 WHERE A.CATEGORY_ID = B.CATEGORY_ID
   AND B.CATEGORY_ID = C.CATEGORY_ID
   AND B.CATEGORY_SET_ID = D.CATEGORY_SET_ID
   AND A.LANGUAGE = 'US'
   --AND D.CATEGORY_SET_NAME = 'ENTER CATEGORY NAME'
   AND D.LANGUAGE = 'US'
   --AND F.ORGANIZATION_CODE='ENTER ORG NAME'
   --AND E.SEGMENT1 =  'ENTER PRODUCT NUMBER'
   --AND B.ORGANIZATION_ID= 'ENTER ORGANIZATION ID'
   AND B.INVENTORY_ITEM_ID=E.INVENTORY_ITEM_ID
   AND B.ORGANIZATION_ID=E.ORGANIZATION_ID
   AND B.ORGANIZATION_ID=F.ORGANIZATION_ID;