Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
MVP
MVP

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
Highlighted
MVP
MVP

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