Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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














Community Browser