topic RangeSum using RowNo is not resetting in a table as the dimension changes in App Development

RangeSum using RowNo is not resetting in a table as the dimension changes

wcoleman0908 — Fri, 12 Apr 2024 16:56:48 GMT

Were trying to calculate hours accumulated across the Fiscal_QTR field.

When the Fiscal_QTR field changes, the hours needs to reset and start accumulating again. The image on the left is what is returning from the line of code below.

RangeSum(above(Sum(Hours Amount]),0,RowNo()))

The line on the right is what I expected, to restart from 1 as the Fiscal_QTR changes.

The ultimate goal is to add up cumulative hours restarting as the Fiscal_QTR field changes. Below I'm showing a table as an example but ideally I want to visualize as a Qlik Sense line chart that shows across Fiscal_QTR's.

Any help is appreciated.

Re: RangeSum using RowNo is not resetting in a table as the dimension changes

Anil_Babu_Samineni — Sat, 13 Apr 2024 15:18:56 GMT

If i understand correctly, You want to repeat the sequence based on Fiscal QTR.

1. Why can't be Right([Fiscal QTR], 1) // this is simplest solution.

2. You can create a field like

AutoNumber([Fiscal QTR], IterNo())

etc.

Re: RangeSum using RowNo is not resetting in a table as the dimension changes

marcus_sommer — Mon, 15 Apr 2024 12:07:17 GMT

Within a table you may add the year as dimension but I assume in a line-chart it won't lead to the wanted visualization. But the second/third parameter of the above could be expressions / references and therefore the years and quarters could be queried. You may approach the needed above() values by just querying the years/quarters in parallel expressions.