Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jhona1737
Contributor III
Contributor III

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

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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

View solution in original post

4 Replies
petter
Partner - Champion III
Partner - Champion III

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

petter
Partner - Champion III
Partner - Champion III

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Thank I just saw the app!!