sum agg and Total

apthansh — Sat, 16 Nov 2024 04:07:36 GMT

I have the below expression - I want to calculate the Total aggregate by ID...How can I do that.

1.Expression1:

sum(aggr(
if(GetFieldSelections([Type])='Sub',

(If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ]))*-1),

If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ]))),[ID]))

2:Expression 2 :

sum(Total(aggr(
if(GetFieldSelections([Type])='Sub',

(If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ]))*-1),

If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ])))),[ID]))

The expression is not working.Any help please.

Secons expression

Re: sum agg and Total

Anil_Babu_Samineni — Tue, 19 Mar 2019 11:30:01 GMT

Is this working for you?

if(GetFieldSelections([Type])='Sub', (If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors), sum([Annual Expense ]))*-1), If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors),
sum([Annual Expense ])))

May be like this?

sum(TOTAL <ID> aggr(if(GetFieldSelections([Type])='Sub', (If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors), sum([Annual Expense ]))*-1), If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors),
sum([Annual Expense ]))),[ID]))

topic Re: sum agg and Total in QlikView

sum agg and Total

Re: sum agg and Total