topic QS Rangesum Not show all Values in App Development

QS Rangesum Not show all Values

hoangly — Fri, 04 Oct 2019 14:57:26 GMT

Hi All,

I have a a table, and I need a Accumulate Chart for all Values.

My table has Week Start in 201906. Using Rangesum function I can get Cumulative Values.

But when I try to show in the Chart Weeks starting from week 22, all values of weeks before that week have been ignored in the cumulative calculation.

The Chart should have in week 22 , value 675989 (this is the **bleep** Value till w22), and Not 25165 (this is the weekly value of w22).

Any idea on sort out this?

Thank you!

Ly.

Re: QS Rangesum Not show all Values

Lisa_P — Mon, 07 Oct 2019 23:56:28 GMT

This should work:
rangesum(above(
Total sum({$< WeekYear = {">= 201922"} >}
[Weekly Qty] )
,0, rowno(Total)))
+
sum( {<WeekYear={"<201922"}>}[Weekly Qty] )

Re: QS Rangesum Not show all Values

hoangly — Tue, 08 Oct 2019 08:05:21 GMT

Hi Lisa_P,

thank you for your reply, but unfortunately it did not work, since I got wrong value and wrong visualization as well.

Re: QS Rangesum Not show all Values

hoangly — Thu, 10 Oct 2019 14:05:59 GMT

Hi, Anyone has some idea ?

Thank you!

Re: QS Rangesum Not show all Values

Lisa_P — Fri, 11 Oct 2019 00:50:11 GMT

sorry, second part should be
+
sum( TOTAL {<WeekYear={"<201922"}>}[Weekly Qty] )

Re: QS Rangesum Not show all Values

hoangly — Fri, 11 Oct 2019 06:55:38 GMT

Thank you. it works!