Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Add calculated difference row in pivot table

Hi,

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.

diff:

Load

"SEGMENT CODE" as diffseg,

OS_Date ,

OS_Date as diffosdate,

"LOCATION NAME" as diffLocation,

"OUTSTANDING AMOUNT" as diffout

resident Out;

Concatenate

Load

"SEGMENT CODE" as diffseg,

OS_Date,

'Diff' as diffosdate ,

"LOCATION NAME" as diffLocation,

"OUTSTANDING AMOUNT"-Previous("OUTSTANDING AMOUNT") as diffout

Resident Out ;

0 Replies