Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

AGGR with Above function

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

2 Replies
sunny_talwar

Would it be possible to share a sample?

Not applicable
Author


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