Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

subathra
New Contributor II

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
Valued Contributor

Re: Rangesum issue

Hi

Can u plz share a sample app with scrambled data?

Regards

Pratyush

subathra
New Contributor II

Re: Rangesum issue

Hi

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

MVP
MVP

Re: Rangesum issue

May be this

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

subathra
New Contributor II

Re: Rangesum issue

Hi sunny,

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

MVP
MVP

Re: Rangesum issue

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

subathra
New Contributor II

Re: Rangesum issue

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

MVP
MVP

Re: Rangesum issue

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

subathra
New Contributor II

Re: Rangesum issue

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

subathra
New Contributor II

Re: Rangesum issue

sum of the accumulated values is my total