topic Re: Aggr Sum only if set analysis question in QlikView

Aggr Sum only if set analysis question

Fri, 24 Jul 2015 10:22:07 GMT

Hi Folks,

I have a question in which i wanna do the following

A B Sales

a 1 1 10

b 1 1 10

c 1 2 100

d 1 2 100

e 2 1 1,000

f 1 3 10,000

g 2 3 100,000

I wanna sum all the sales vol. that A=1 while distinct B (which sum only once either row a or b, but not both)

I have tried the following formula, however it turns out Nested aggregation not allowed.

=sum(aggr(Sales,only({<A_id={'1'}>} B_id)))

Can anyone help with this.

Thank in advanced.

MK_QSL — Fri, 24 Jul 2015 10:27:52 GMT

=SUM(Aggr(SUM({<A = {1}>}Distinct Sales),A,B))

bbmmouha — Fri, 24 Jul 2015 10:57:30 GMT

=if(sum({<A>}sales)=1,A,B)

Fri, 24 Jul 2015 13:00:47 GMT

Thx a lot , Manish Kachhia.

Your formula work PERFECTLY..