Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a table like the below....
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!
Go to Solution.
Per Model and Item:
AGGR(SUM(DISTINCT Views), Model, Item)
AGGR(SUM(AGGR(SUM(DISTINCT Views), Model, Item)), Model)
Thank you very much!