Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
aminehaddar
Contributor II
Contributor II

table operation in qlik

Hello,

I have this table:

date X
12/2016100
01/2017200
02/2017300
03/2017400
04/2017500

And the objective is :

dateX
12/2016100
01/2017100
02/2017200
03/2017300
04/2017400

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

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

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

Any suggestions please?

Regards,

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

1 Reply
MK_QSL
MVP
MVP

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