Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

johnso2080
New Contributor

Aggregation

Hello,

I have a table like the below....

ModelItemColourViews
A1BLUE4000
A1GREEN4000
A1BLACK4000
A2BLUE1200
A2GREEN1200
B3RED2600

What I want to do is add up the 'Views' for each model, but removing the duplication by colour.

So that the total views for item '1' = 4000, and item '2' = 1200 so the total for model 'A' would be 5200.

I've tried a couple of different Aggr() formula variations but I'm having some trouble! Any advice would be much appreciated!

Thanks

Darren

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Aggregation

Per Model and Item:

AGGR(SUM(DISTINCT Views), Model, Item)

Per model:

AGGR(SUM(AGGR(SUM(DISTINCT Views), Model, Item)), Model)

2 Replies
Not applicable

Re: Aggregation

Per Model and Item:

AGGR(SUM(DISTINCT Views), Model, Item)

Per model:

AGGR(SUM(AGGR(SUM(DISTINCT Views), Model, Item)), Model)

johnso2080
New Contributor

Re: Aggregation

Thank you very much!

Community Browser