topic Referencing a previous record in QlikView

Referencing a previous record

Dayna — Tue, 08 Mar 2011 11:33:00 GMT

Hello All,

I'm hoping that you can help me, I need to reference data from a previous record. What I have is a data source set up as:

Product Date Amount

And what I want to do, is show a data range (From and To), show for each record, the date to is the date in the row and the date from is the previous date for the same product/site/domain.

I've created a basic test app to show you what I mean. I hope you can help me!

Kind Regards,
Dayna

Referencing a previous record

Miguel_Angel_Baeyens — Tue, 08 Mar 2011 11:51:39 GMT

Hello Dayna,

If possible I'd create taht in the script, something like

Data:LOAD Product, Date(Date) AS DateTo, If(Product = Previous(Product), Previous(Date), 'n/a') AS DateFrom, AmountFROM FileORDER BY Product, Date; // Data source

Hope that helps.

EDIT: Checked "Previous(Date) as DateFrom", my fault.

Referencing a previous record

Dayna — Tue, 08 Mar 2011 12:04:39 GMT

Hello Miguel,

Many thanks for your response, I tried it on my script and I get the below which puts the same date in both fields rather than the previous date.

Kind Regards,
Dayna

Referencing a previous record

Miguel_Angel_Baeyens — Tue, 08 Mar 2011 12:06:30 GMT

Yep, I noted after posted I missed a Previous(Date) (obviously) in the script. I corrected it above.

Referencing a previous record

Dayna — Tue, 08 Mar 2011 12:12:49 GMT

Thought that was the case! Looks good! Hope it can work when my app gets more complex!

Many thanks Miguel!