table operation in qlik

[aminehaddar]

Hello,

I have this table:

date	X
12/2016	100
01/2017	200
02/2017	300
03/2017	400
04/2017	500

And the objective is :

date	X
12/2016	100
01/2017	100
02/2017	200
03/2017	300
04/2017	400

exemple: X= 200 - 100 ( 12/2016)  = 100

                X= 300 - 100 ( 12/2016)  = 200

                X= 400 - 100 ( 12/2016)  = 300

Any suggestions please?

Regards,

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension

date

expression

SUM(X)

IF(RowNo()=1,SUM(X),SUM(X)-top(SUM(X)))

make sure that you sort your table by date