Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lewisjackson_eq
New Contributor II

Count previous column measure in a Pivot Table

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:

Date2
Date102/10/201709/10/201723/10/2017
02/10/20173029
09/10/2017157
23/10/201710

I want it to look like the following, where it is adding the previous column as well for a running total so to speak:

Date2
Date102/10/201709/10/201723/10/2017
02/10/2017303241
09/10/20171522
23/10/201710

would someone be able to point me in the right direction for this?

Cheers

3 Replies
MVP
MVP

Re: Count previous column measure in a Pivot Table

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

silambarasan130
Contributor II

Re: Count previous column measure in a Pivot Table

You have Column() function.

Use Column(1) + Sum(Value)

It will add the previous column value with the sum(value)

lewisjackson_eq
New Contributor II

Re: Count previous column measure in a Pivot Table

This helped immensely. Thanks and bunch!

Community Browser