topic Re: aggr function help in QlikView

aggr function help

thierrytt1102 — Sun, 17 Mar 2013 17:22:28 GMT

Hello All,

I made a fomula which is good for an individual item :

sum(aggr(sum({<TypeDocument={SO,CO}, GL_Class_SO={'FNE'}>} SalesQuantity), ItemNo) * aggr(sum(DirectLaborItem), ItemNo))

(DirectLaborItem is the direct labor for an individual item)

When I unselect the item, I have got a result for all the item which is OK as well.

Now, I'd like to have the result of all my items even if I select one.

I made this:

sum(aggr(sum({1<Period=P(Period), TypeDocument={SO,CO},GL_Class_SO={'FNE'}>} TOTAL SalesQuantity), ItemNo) *aggr(sum(DirectLaborItem), ItemNo))

but the result is false.

Could you help me?

Thank a lot in advance

T T

Re: aggr function help

swuehl — Sun, 17 Mar 2013 18:19:36 GMT

It is not trivial to answer your question, not knowing your data model etc. If possible, upload a small sample file, this makes it easier for us to help you.

If you want to ignore selections in field ItemNo (that's what I understood), I would start with ignoring this field's selection in a set expression in all of your aggregation functions:

= sum( {<ItemNo= >}

aggr(sum({<ItemNo=, TypeDocument={SO,CO}, GL_Class_SO={'FNE'}>} SalesQuantity), ItemNo) * aggr(sum({<ItemNo=>} DirectLaborItem), ItemNo)

)

[And I think this should be equivalent:

= sum( {<ItemNo= >}

aggr(

sum({<ItemNo=, TypeDocument={SO,CO}, GL_Class_SO={'FNE'}>} SalesQuantity)* sum({<ItemNo= >} DirectLaborItem)

, ItemNo)

)

]

Re: aggr function help

thierrytt1102 — Sun, 17 Mar 2013 20:06:16 GMT

Thank you swuehl,

It solved my issue. I didn't tought about it.