topic Re: Qlik Sense Table with RangeSum and Two Dimensions in App Development

Qlik Sense Table with RangeSum and Two Dimensions

samyurchuk — Wed, 22 Dec 2021 20:40:09 GMT

I have a table with the following columns: NET_BILLING_AMT, Cumulative Sales and Material ID. Using the formula rangesum(above(sum(NET_BILLING_AMT),0,rowno())) for Cumulative Sales, everything works fine.

I would like to add another Dimension to the table called MATERIAL_NAME. I've tried aggr(rangesum(above(sum(NET_BILLING_AMT),0,rowno())), MATERIAL_ID, MATERIAL_NAME) for Cumulative Sales after adding the MATERIAL_NAME to the table but the column is not accumulating.

Re: Qlik Sense Table with RangeSum and Two Dimensions

marcus_sommer — Fri, 20 Sep 2019 12:07:40 GMT

Just try it without the aggr() but with TOTAL in rowno() and/or above() like:

rangesum(above(TOTAL sum(NET_BILLING_AMT),0,rowno(TOTAL)))

- Marcus

Re: Qlik Sense Table with RangeSum and Two Dimensions

samyurchuk — Fri, 20 Sep 2019 13:22:19 GMT

Perfect! That worked. Thanks for the help😊, Marcus.