aggr Set Analysis

andrea90casa — Sat, 09 Sep 2017 14:52:16 GMT

I have this situation:

Name	Year	Category	Value
Alfa	2015	Cat_01	1000
Alfa	2014	Cat_01	800
Alfa	2013	Cat_01	900
Gamma	2015	Cat_02	1500
Gamma	2014	Cat_02	2000
Beta	2015	Cat_01	1400
Epsilon	2014	Cat_01	800

And i would like to create a chart with Year as dimension and then the total amount of value by category. For example if i select Alfa i would like to obtain (in this case the category will be Cat_01):

2015) 2400

2014) 1600

2013) 900

I tried to write this formula:

Aggr(nodistinct sum({<Name>} Value),Category)

But if i do this it gives to me the entire value wihtout considering Year fields.

How can i solve this problem?

Andrea

Re: aggr Set Analysis

swuehl — Sat, 09 Sep 2017 15:02:12 GMT

Try using Year as dimension and as expression

=Sum({<Category = p(), Name= >} Value)

Re: aggr Set Analysis

andrea90casa — Sat, 09 Sep 2017 15:06:09 GMT

Thank you Stefan,

I will go to see what is that p() and how it works

Andrea

topic aggr Set Analysis in QlikView

aggr Set Analysis

Re: aggr Set Analysis

Re: aggr Set Analysis