Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
grajmca_sgp123
Creator
Creator

aggr,range sum functions with set analysis

Hi all,

how do we write this if condition by using set anlysis

if(BS= 'P',sum( aggr( rangesum( above( sum([val]),0,12)),YearMonthNumber)))

Thanks in adavce

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

If you had some more context to it I might be more sure if this is a correct solution - but I guess:

Sum( Aggr( RangeSum( Above( Sum( { < BS={'P'} > } [val]) , 0 , 12 ) ) , YearMonthNumber ) )

View solution in original post

1 Reply
petter
Partner - Champion III
Partner - Champion III

If you had some more context to it I might be more sure if this is a correct solution - but I guess:

Sum( Aggr( RangeSum( Above( Sum( { < BS={'P'} > } [val]) , 0 , 12 ) ) , YearMonthNumber ) )