Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
shri
Contributor II
Contributor II

Subtracting to values

How to subtract two consecutive rows in a single column or/

how to subtract two rows based on the selection of the filter ?

If Filter pane is of : Materials 

Material     Qty     Result should be 

1234            50               50-20= 30

1334            20               20-10=10

1554            10               10-50= -40

1234            50               50

 

 

 

2 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Shri,

Add the following measure:

Sum(QTY)- Below(Sum(QTY))

Jordy

Climber 

Work smarter, not harder
shri
Contributor II
Contributor II
Author

It doesn't give me the correct answer 🙁