topic Re: Subtotal not work on expression with Aggr in QlikView

Subtotal not work on expression with Aggr

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

Hello

I have an expression which works and brings the correct numbers on a line-by-line basis but the totals do not agree to the lines above. Why would this be and is there anyway to correct this?

+IF(

SUM(Aggr( sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>}IS_IFRS_GBP),entity_region,entity_description)) >0,

SUM(Aggr( sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>}IS_IFRS_GBP),entity_region,entity_description))

,0)

Many thanks

Paul

Re: Subtotal not work on expression with Aggr

sunny_talwar — Fri, 15 Apr 2016 17:09:22 GMT

May be this:

=Sum(Aggr(If(Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>} IS_IFRS_GBP) > 0,

Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>} IS_IFRS_GBP), 0), entity_region, entity_description))

Re: Subtotal not work on expression with Aggr

paul_ripley — Mon, 18 Apr 2016 07:55:11 GMT

Thanks so much for that, was very helpful

Paul