topic Re: Aggr and Sum in Table in QlikView

Aggr and Sum in Table

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following expression:

sum(Aggr(

(SUM({<format= > }weight) / SUM(TOTAL{<format= > } weight))

(SUM( {<orderdate= {">=$(=max(obj_date_prod))"}, format=, flag_object={'1'}> } object_value) /100)

,Type,orderdate,format))

That gives me the following and it's OK, when I have selected Type = Product 1:

Type	OrderDate	Format	Expression
			3,57%
Product 1	28/5/2018	Stuff	0,12%
Product 1	28/5/2018	Mix	3,45%

But if I clear my selections for Type, then I see it like this:

Type	OrderDate	Format	Expression
			17,63%
Product 1	28/5/2018	Stuff	4,51%
Product 1	28/5/2018	Mix	3,54%
Product 2	28/5/2018	Other	2,10%
Product 3	28/5/2018	Other 2	1,50%
Product 4	28/5/2018	Random	3,80%
Product 5	28/5/2018	Min	2,18%

Is there any way to keep the same value like in table 1 for all my Types?

Thank you!!!

sunny_talwar — Tue, 12 Jun 2018 14:51:40 GMT

Would you be able to share a sample?

PrashantSangle — Tue, 12 Jun 2018 14:59:17 GMT

might be you need to group your TOTAL type wise

try below

sum(Aggr(

(SUM({<format= > }weight) / SUM(TOTAL<Type> {<format= > } weight))

(SUM( {<orderdate= {">=$(=max(obj_date_prod))"}, format=, flag_object={'1'}> } object_value) /100)

,Type,orderdate,format))

Regards,