Discussion Board for collaboration related to QlikView App Development.
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).
If(Above(TOTAL Material) = Material, Above(TOTAL Expression) - [C] + [B], [A] - [C] + [B])
View solution in original post