Discussion board where members can get started with QlikView.
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])
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).
Go to Solution.
If(Above(TOTAL Material) = Material, Above(TOTAL Expression) - [C] + [B], [A] - [C] + [B])
View solution in original post