Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mahendragaur
Contributor

Pivot addition of previous rows

Hello All,

I want to add previous rows value in pivot of qlikview. Below is my table and expression 

if(Above(Material)=Material   ,    Above(Expression)-[C]+[B]  ,    [A]-[C]+[B])

 Capture.PNG

 

It is working fine for same date but if date is different it treat it as separate row and doesn't add the expression value of previous day (last row).

1 Solution

Accepted Solutions

Re: Pivot addition of previous rows

Try this

If(Above(TOTAL Material) = Material, Above(TOTAL Expression) - [C] + [B], [A] - [C] + [B])

View solution in original post

1 Reply

Re: Pivot addition of previous rows

Try this

If(Above(TOTAL Material) = Material, Above(TOTAL Expression) - [C] + [B], [A] - [C] + [B])

View solution in original post