0 Replies Latest reply: Jan 26, 2013 12:30 PM by schoupperudi RSS

    Set-analysis_composition

      qlikview_set_analysis.png


































































































































































































































































































































































































      GANGGANG
        DESCRIPTION
      CUSTOMER_NAMESHIFTDATE SHIFTSTART SHIFTEND SHIFTLABOUR_HOURSPART_NOToolROLE_CODEDESCRIPTIONTO_DATE_FROM_TIMETO_DATE_TO_TIMEWEIGHT HANDLEDLOAD QTYIDLE TIME
      200HUBO 1HamburgerS111/01/20136:00:0013:45:007:15:00COLA-ID_RAINcannot start unload
        due rain
      6:30:006:45:00174162810:15:00
      FANTA-ID_RAINcannot start unload
        due rain
      6:30:006:45:003324540:15:00
      SPRITE ID_RAINcannot start unload
        due rain
      6:30:006:45:001051250:15:00
      DUVEL 694702185
      PALM 8377240
      Total 9963933150:45:00
      WEIGHT_HANDLED
        : =sum({<ROLE_CODE={'ID*','FA*'}>}Aggr(sum(WEIGHT_HANDLED),PART_NO))
      LOAD_QTY
        : =sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(LOAD_QTY),PART_NO))
      IDLE
        TIME : ==sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(IDEL_TIME),PART_NO))
      How
        I would to have it
      GANGGANG DESCRIPTIONCUSTOMER_NAMESHIFTDATE SHIFTSTART SHIFTEND SHIFTLABOUR_HOURSPART_NOWEIGHT HANDLEDLOAD QTYToolROLE_CODEDESCRIPTIONTO_DATE_FROM_TIMETO_DATE_TO_TIMEIDLE TIME
      200HUBO 1HamburgerS111/01/20136:00:0013:45:007:15:00COLA17416281VF02FA_TRUCwaiting for truck6:00:006:15:000:15:00
      FANTA332454KR01FA_OPENwaiting for truck to
        be ready to unload
      6:15:006:30:000:15:00
      SPRITE105125 ID_RAINcannot start unload
        due rain
      6:30:006:45:000:15:00
      DUVEL694702185
      PALM8377240
      Total996393315 0:45:00
      need
        to have a set-analysis to read out all the used tools
      need
        to change the place of WEIGHT HANDLED AND LOAD QTY
      need
        to be able to read out all the role_codes

      GANG
      GANG
        DESCRIPTION
      CUSTOMER_NAME
      SHIFT
      DATE SHIFT
      START SHIFT
      END SHIFT
      LABOUR_HOURS
      PART_NO
      Tool
      ROLE_CODE
      DESCRIPTION
      TO_DATE_FROM_TIME
      TO_DATE_TO_TIME
      WEIGHT HANDLED
      LOAD QTY
      IDLE TIME


      200
      HUBO 1
      Hamburger
      S1
      11/01/2013
      6:00:00
      13:45:00
      7:15:00
      COLA
      -
      ID_RAIN
      cannot start unload
        due rain
      6:30:00
      6:45:00
      174162
      81
      0:15:00


      FANTA
      -
      ID_RAIN
      cannot start unload
        due rain
      6:30:00
      6:45:00
      33245
      4
      0:15:00


      SPRITE

      ID_RAIN
      cannot start unload
        due rain
      6:30:00
      6:45:00
      10512
      5
      0:15:00


      DUVEL





      694702
      185



      PALM





      83772
      40



      Total





      996393
      315
      0:45:00





















      WEIGHT_HANDLED
        : =sum({<ROLE_CODE={'ID*','FA*'}>}Aggr(sum(WEIGHT_HANDLED),PART_NO))












      LOAD_QTY
        : =sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(LOAD_QTY),PART_NO))













      IDLE
        TIME : ==sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(IDEL_TIME),PART_NO))



















































      How
        I would to have it




































      GANG
      GANG DESCRIPTION
      CUSTOMER_NAME
      SHIFT
      DATE SHIFT
      START SHIFT
      END SHIFT
      LABOUR_HOURS
      PART_NO
      WEIGHT HANDLED
      LOAD QTY
      Tool
      ROLE_CODE
      DESCRIPTION
      TO_DATE_FROM_TIME
      TO_DATE_TO_TIME
      IDLE TIME


      200
      HUBO 1
      Hamburger
      S1
      11/01/2013
      6:00:00
      13:45:00
      7:15:00
      COLA
      174162
      81
      VF02
      FA_TRUC
      waiting for truck
      6:00:00
      6:15:00
      0:15:00


      FANTA
      33245
      4
      KR01
      FA_OPEN
      waiting for truck to
        be ready to unload
      6:15:00
      6:30:00
      0:15:00


      SPRITE
      10512
      5

      ID_RAIN
      cannot start unload
        due rain
      6:30:00
      6:45:00
      0:15:00


      DUVEL
      694702
      185








      PALM
      83772
      40








      Total
      996393
      315





      0:45:00





















      need
        to have a set-analysis to read out all the used tools
















      need
        to change the place of WEIGHT HANDLED AND LOAD QTY














      need
        to be able to read out all the role_codes