Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mahendragaur
Creator
Creator

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
sunny_talwar

Try this

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

View solution in original post

1 Reply
sunny_talwar

Try this

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

View solution in original post