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: 
subathra
Partner - Contributor III
Partner - Contributor III

Rangesum issue

Hi,

Is there anyway to do this calculation without using aggr function

Sum({$<FiscalYear={"$(=Year(Max(FiscalYear)))"}>}

Aggr(RangeSum(Above(Sum({$<EntryDate={"<=$(=max(EntryDate))"}>}ClosingBalanceAmount),0,RowNo())),Date))

12 Replies
prat1507
Specialist
Specialist

Hi

Can u plz share a sample app with scrambled data?

Regards

Pratyush

subathra
Partner - Contributor III
Partner - Contributor III
Author

Hi

i cant share the app..the app size is little bit large

sunny_talwar

May be this

RangeSum(Above(Sum({$<EntryDate={"<=$(=max(EntryDate))"}>}ClosingBalanceAmount),0,RowNo())) * Avg({$<FiscalYear={"$(=Year(Max(FiscalYear)))"}>}1)

subathra
Partner - Contributor III
Partner - Contributor III
Author

Hi sunny,

It is working ...but i am not getting the exact value

sunny_talwar

Do you have Date as your dimension? Also, do you have the same sort order in your chart as in your script?

subathra
Partner - Contributor III
Partner - Contributor III
Author

Thanks sunny..Its working...but how can i display the total value

sunny_talwar

What is total when you are accumulating? Sum of rows or the last accumulated value?

subathra
Partner - Contributor III
Partner - Contributor III
Author

i am displaying this measure in a table...so here i need to show the total value as label

subathra
Partner - Contributor III
Partner - Contributor III
Author

sum of the accumulated values is my total