Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Aggregation table

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
250444Biscuit breuk295
250444Ingeperste splinters195
250444Persstrepen395
250444Plakkers195
250444Zwarte punten (veront.)1095
250445Biscuit breuk2168
250445Ingeperste splinters2168
250445Persstrepen6168
250445Splinters1168
250445Zwarte punten (veront.)5168
250447Ingeperste splinters1107
250447Persstrepen4107
250447Persstrepen10107
250447Plakkers10107
250447Splinters2107
250447Zwarte punten (veront.)1107

Pls advice

Robert

3 Replies
sunny_talwar

May be like this

1) Sum([Failure value])

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

sunny_talwar

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

Count(TOTAL <Workorder> Workorder)

Anonymous
Not applicable
Author

Hi Robert,

Sum(TOTAL <Workorder> [Failure Value])

Max(TOTAL <Workorder> [# Failures])

Regards!