Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
LAlvarado
Partner - Contributor
Partner - Contributor

AGGR Syntax

I'm having a problem with an AGGR because when I add this part into the syntax it stops working  showing the correct amount (it doesn't affect the current expression)

COUNT(if(AGGR(RANGESUM(ABOVE(SUM(Monto),0,ROWNO())),(Mes, (IdType, (=SUM(Monto), Descending))))<0.75*SUM(TOTAL Monto),1,0))

Labels (1)
1 Reply
sunny_talwar

How about if you do this

Sum(Aggr(
  If(RangeSum(Above(Sum(Monto), 0, ROWNO())) < 0.75 * Sum(TOTAL Monto), 1, 0)
, Mes, (IdType, (=Sum(Monto), DESC))))