Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
pamaxeed
Partner - Creator III
Partner - Creator III

Accumulated Sum - Straight Table

Hi all,

I need help with the above function.

I have following straight table:

Capture.PNG

The relevant column ist TWR YTD, which should reflect the accumulated SUM from TWR Täglich.

The logic should be adjusted here with following requirements

  1. Acc Sum by ID and ISIN
  2. If Flag IstBeginn = 1 we should start to sum up from 0

In this case the red underlined values should be all 0 as we do not have any specific value in TWR Täglich column.

I used the following function:

  • Rangesum( above(total Column(6),0,rowno(total)))

We have to tweak with the last 2 parameters and maybe use the AGGR function by grouping the resultset by ID and ISIN (not sure if needed).

Is there anyone who can support me here?

Thanks,

Patric

1 Solution

Accepted Solutions
sunny_talwar

Have you tried this?

RangeSum(Above(Column(6), 0, RowNo()))

View solution in original post

4 Replies
sunny_talwar

Have you tried this?

RangeSum(Above(Column(6), 0, RowNo()))

sunny_talwar

You might have to create a new field in the script like this

LOAD Id*ISIN as Key

and then try like this

Aggr(RangeSum(Above(Column(6), 0, RowNo())), Ket, DateField)

pamaxeed
Partner - Creator III
Partner - Creator III
Author

Looks good!

Can you explain me what is the difference to mine one?

Thanks!

sunny_talwar

By design when you add TOTAL to Above and RowNo, they accumulative regardless of the chart dimension... where as without TOTAL, the value changes based on dimension change.