Qlik Community

Qlik Sense App Development

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

jhona1737
New Contributor II

Accumulative Values

Hi All, I been trying to accumulative values in a horizontal table, I was able to create on a vertical one using this variables:

SET [accum] ="RangeSum(Above(";

SET [/accum]=",0,rowNo(TOTAL)))";

Capture.PNGCapture1.PNG

I am trying to keep track of inventory.

Thank you all

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Accumulative Values

First of all you have to change your Above() function to a Before() function since you have pivoted the data. You might have to change other things too if you have a different data model than I have tried to guess at...

You can have a look at how it works in the app I quickly made where it works well:

Screenshot from 2018-03-29 15-19-58.png

4 Replies
MVP
MVP

Re: Accumulative Values

Could you share how your expression looks like for the measures you have?

MVP
MVP

Re: Accumulative Values

First of all you have to change your Above() function to a Before() function since you have pivoted the data. You might have to change other things too if you have a different data model than I have tried to guess at...

You can have a look at how it works in the app I quickly made where it works well:

Screenshot from 2018-03-29 15-19-58.png

jhona1737
New Contributor II

Re: Accumulative Values

Hi Petter,

That's great thank you, this was the expression I used for the table:

$(accum)sum({<[Item Category Code]={'TILAPIA'}>}MonthlyInventoryLBS) $(/accum)+

($(accum) sum({<[Item Category Code]={'TILAPIA'}>}Total_Po_Qty_Lbs) $(/accum)+

$(accum) sum({<[Item Category Code]={'TILAPIA'}>}PIQtyBase) $(/accum))-

($(accum) sum({<[Item Category Code]={'TILAPIA'}>}BaseUnitSOQTY) $(/accum)+

$(accum) sum({<[Item Category Code]={'TILAPIA'}>}BaseQTYInvocie) $(/accum))

but is does not give the total balance as you table could you please show the expression that you used for both types of tables.

Thank you,

jhona1737
New Contributor II

Re: Accumulative Values

Thank I just saw the app!!

Community Browser