Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Cross Aggregation

My data look like this:

 

Global_IDLocal_IDRefTypeLabelnT1nT2nT3
20160815913514-1Foo111
20160815913515-1Bar111
20160815913516-1Bar111
201608159135179135142-
201608159135189135152-
201608159135199135162-
201608159135209135173-
201608159135219135183-
201608159135229135193-
2016081612345

There is a variable number of type=1 per Global_ID. Each T=1 can have a number of T=2, which again holds a couple of T=3. Variables nT1 to nT3 is what I want to achieve in order to pivot all data (total number and average of type=2 and 3 per Label). When I aggregate now per Aggr(Sum(if([Type]=2,1,0)),[Ref]) these values are not written into the line with the label. Any idea how to do this "cross aggregation"? (Didn't find a better caption)

Community Browser