Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sfbi
Creator
Creator

RangeSum Above TOTAL

Hi,

I have this measure to calculate running totals of this aggr table:

 

 

rangesum(ABOVE(total
sum({1}
AGGR({1} sum(VLPAGARECEBERSALDO)
,(IDSUBCATEGORIA,(NUMERIC,ASCENDING)),(IDCATEGORIA,(NUMERIC,ASCENDING)), ([DATE],(NUMERIC,ASCENDING)))),0,rowno(total)))

 

 


The result is correct, when no Date Selection is applied. When Date is selected, the expression is ignoring the date selection.

sfbi_0-1642109653343.png


What I need is when selecting any Date, the Range Value keeps the correct running total for that date, idcategoria, idsubcategoria and only show the selected date(s).

Thank you

Labels (1)
  • SaaS

0 Replies