Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Opening and Closing

Hi,

I have data like:

Tx               Type     Qty

2013/1/1        In          30 pcs

2013/3/1     Out          -5 pcs

2014/1/28     In            10 pcs

2014/5/20     Out          -13 pcs

2015/1/4       In          8 pcs

2015/4/6     Out          -7 pcs

I would like to build a chart to show movement in Qty to see the closing trend.

               Opening          In               Out               Closing

2013          0                   30               -5               25

2014          25                10               -13               22

2015          22               8                    -7               23

Can anyone help me to fill-in below ........in set analysis

Sum({<Year=,Month=,Quarter=,..............>} InQty) - Sum({<Year=,Month=,Quarter=,....................>} OutQty)

Community Browser