Set-analysis_composition

Mon, 26 Jan 2026 18:19:17 GMT

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

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

0:15:00

FANTA

ID_RAIN

cannot start unload
due rain

6:30:00

6:45:00

33245

0:15:00

SPRITE

ID_RAIN

cannot start unload
due rain

6:30:00

6:45:00

10512

0:15:00

DUVEL

694702

185

PALM

83772

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

11/01/2013

6:00:00

13:45:00

7:15:00

COLA

174162

VF02

FA_TRUC

waiting for truck

6:00:00

6:15:00

0:15:00

FANTA

33245

KR01

FA_OPEN

waiting for truck to
be ready to unload

6:15:00

6:30:00

0:15:00

SPRITE

10512

ID_RAIN

cannot start unload
due rain

6:30:00

6:45:00

0:15:00

DUVEL

694702

185

PALM

83772

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

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

topic Set-analysis_composition in QlikView

Set-analysis_composition