Time Series - Calculate Difference (Derive calculated measures)

[gnmq]

Hi all,

I need urgent help with plotting line chart using Qlik Sense.

I have a set of finance data - consists of the following fields:

Date, Code, ProductKey, DistributorKey, ProductCode, Sales, NewField

26-05-2019, ProdK1, DK1, PCode1, 5000, 0

27-05-2019, ProdK1, DK1, PCode1, 6000, 1000

New Field = Today's Sales - Yesterday's Sales

How do I derive the new field in Qlik to show the daily changes?

Appreciate if someone can help with this implementation. Thank you.

In the dashboard, there will be filters applied such as being able to see the changes over time for various product name selected...

Line Chart -

X axis: Date

Measures: Total Sales and NewField (Changes)