Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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 🙁