Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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