Discussion board where members can get started with QlikView.
I am trying to add row in pivot by calculating difference of two other rows of outstandingg Amount.
But i got incorrect value.please help me to figure out what is the issue or else some other method to calcullat it.
here is the snapshot of output and script.
"SEGMENT CODE" as diffseg,
OS_Date as diffosdate,
"LOCATION NAME" as diffLocation,
"OUTSTANDING AMOUNT" as diffout
'Diff' as diffosdate ,
"OUTSTANDING AMOUNT"-Previous("OUTSTANDING AMOUNT") as diffout
Resident Out ;