Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

DIFFERENCE BETWEEN DATES

I have a table with date, customer, quantity and I need to know the variation amount from the previous date

DATECUSTOMERQUANTITY
2016-01-013125
2016-01-033148
2016-01-072480
2016-01-12185
2016-01-213198

EXAMPLE: CUSTOMER 3 ON 21TH ->  198-148= 50

1 Reply
MVP
MVP

Re: DIFFERENCE BETWEEN DATES

If you want to calculate this in the script:

Result:

LOAD

     Customer,

     Date,

     Quantity,

     If(Previous(Customer) = Customer, Quantity- Previous(Quantity) ) as Diff

RESIDENT YourTable

ORDER BY Customer, Date;

DROP Table YourTable;