Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

dsharmaqv
Contributor III

Calculating Absolute and Net values

Hi

I have a requirement where I have to calculate the sum of absolute and net values

Please refer below data sets for your refrance.

YearMonthBalance
2010Jan100
2010Feb-100
2010Mar200
2011Jan300
2011Feb-100
2011Mar-500
2011Apr300
2012Jan-100
2012Feb100

Can some one help me in achiving the functionality using Pivot table.

1 Reply

Re: Calculating Absolute and Net values

Add an expression sum(Balance). It will give you the absolute amounts per month and the net values per year.


talk is cheap, supply exceeds demand
Community Browser