topic Re: Pivot Table - Adding Previous Column Values in QlikView

Pivot Table - Adding Previous Column Values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Helo,

I have this data

I am trying to create a table that looks like this

I could get "Start", "Up" and "Down" in qlikview using a pivot table. Couldnt get "Change" yet.

How do I get access to previous column values? I tried using before and above but still couldnt get the result.

Attached sample

sunny_talwar — Wed, 10 Aug 2016 18:19:56 GMT

May be try this:

if(match(Name, 'Initial', 'Final'), '', RangeSum(Before(Sum(Value), 0, ColumnNo())))

swuehl — Wed, 10 Aug 2016 18:20:51 GMT

For Change, try

if(match(Name, 'Initial', 'Final'), '', Rangesum(before(sum(Value),0,ColumnNo())))