topic Re: Aggregation table in QlikView

Aggregation table

Anonymous — Thu, 15 Sep 2016 10:56:15 GMT

Hi Guys,

I'm not quite handy with aggregation table, so I need a bit assistance.

The data is straight, 2 dimensions; workorder & Failures. When I create a pivot table I need the sum of the Failure value and the Total of # Failures. The aggregation level is the workorder.

So Total Workorder 250444 = 95, 250445=168 etc.

Workorder	Failure	Failure value	# Failures
250444	Biscuit breuk	2	95
250444	Ingeperste splinters	1	95
250444	Persstrepen	3	95
250444	Plakkers	1	95
250444	Zwarte punten (veront.)	10	95
250445	Biscuit breuk	2	168
250445	Ingeperste splinters	2	168
250445	Persstrepen	6	168
250445	Splinters	1	168
250445	Zwarte punten (veront.)	5	168
250447	Ingeperste splinters	1	107
250447	Persstrepen	4	107
250447	Persstrepen	10	107
250447	Plakkers	10	107
250447	Splinters	2	107
250447	Zwarte punten (veront.)	1	107

Pls advice

Robert

Re: Aggregation table

sunny_talwar — Thu, 15 Sep 2016 10:59:11 GMT

May be like this

1) Sum([Failure value])

2) Count(TOTAL <Workorder> [# Failures])

Re: Aggregation table

sunny_talwar — Thu, 15 Sep 2016 11:00:28 GMT

I am not sure what the values are coming from, but may be you need this for 2:

Count(TOTAL <Workorder> Workorder)

Re: Aggregation table

Anonymous — Thu, 15 Sep 2016 11:01:51 GMT

Hi Robert,

Sum(TOTAL <Workorder> [Failure Value])

Max(TOTAL <Workorder> [# Failures])

Regards!