topic AGGR with Above function in QlikView

AGGR with Above function

Wed, 25 Nov 2020 16:16:04 GMT

if ((Sum({<Article_No={'*'}-{''},Seasonwise={'Current'}>} net_qty ))<>0,

(Sum({<Article_No={'*'}-{''},Seasonwise={'Current'}>} net_qty)),

aggr(Above( Sum({<Article_No={'*'}-{''},Seasonwise={'Current'}>} net_qty )),Entity,GLZone,Store_Code,Rolling_Month))

aggr function not working in this. if i am trying 1 in else condition it is showing 1 , if i am trying only above statement it is working for first two months. any1 can help

Re: AGGR with Above function

sunny_talwar — Tue, 15 Mar 2016 09:51:07 GMT

Would it be possible to share a sample?

Re: AGGR with Above function

Tue, 15 Mar 2016 10:00:27 GMT

Please find the attachment. I want closing stock current to be copied in opening stock current of next month