Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Compare 2 rows and show only rows with difference

Hi There

I have following data , I want to compare 2 immediate rows and show only those rows which has difference in Qty.

Dim:

LOAD *

INLINE [

  ID, Qty, Version

  1, 400, 1

  1, 400, 2

  1, 500, 3

  1, 600, 4

  2, 600, 2

  2, 700, 3

  2, 500, 4

];

Report Output should look like below:

id

oldqty

newqty

oldversion

newversion

Difference

1

400

500

2

3

100

1

500

600

3

4

100
260070023100
270050034-200

Can you please suggest something?

I tried with Above function.

thanks in advance.

1 Reply

Re: Compare 2 rows and show only rows with difference

Check this

Capture.PNG

Community Browser