Discussion board where members can get started with Qlik Sense.
Hi!, I'm looking to count the totals of columns by including the previous weeks data as well in a pivot table. Current data looks like this:
I want it to look like the following, where it is adding the previous column as well for a running total so to speak:
would someone be able to point me in the right direction for this?
You have the Before () inter-record chart functions (and it's siblings).
Before ( Sum (Qty) ) +Sum (Qty) )
Is an example on how you can keep a running total column-wise.
Here is the documentation and further examples:
Before - chart function ‒ Qlik Sense
You have Column() function.
Use Column(1) + Sum(Value)
It will add the previous column value with the sum(value)
This helped immensely. Thanks and bunch!