topic Expand data To get record for each date in QlikView

Expand data To get record for each date

pkelly — Wed, 23 Jun 2010 09:52:39 GMT

The atatched spreadsheet shows the data that I am working with in Excel form (I am actually pulling this from a progress database).

Each time we get a new currency rate, we create a new record.

The system looks at the transaction date, looks up the currency table and applies the appropriate rate.

in the attached table, a transaction posted on the 25/11/2001 would pick up a rate of 0.45 with a transaction posted 27/11/2001 picking up 2.25.

To make things simpler on the reporting side, I would like to create a QVD table whioch has a record for each date.

So I would have something like....

How do I acheive this?

Any help greatly appreciated....

sparur — Wed, 23 Jun 2010 10:02:08 GMT

Hello, Paul.

you can to use IntervalMatch function for creating records for each date.

sparur — Wed, 23 Jun 2010 10:03:20 GMT

at first, create endDate field and then use intervalMatch

pkelly — Wed, 23 Jun 2010 10:19:53 GMT

Thanks Anatoly

Have never used intervalMatch - could you possibly show post an example of how I can acheive this?

sparur — Wed, 23 Jun 2010 11:19:42 GMT

Paul, see my example

pkelly — Wed, 23 Jun 2010 13:07:14 GMT

Thanks Anatoly - this has done the trick....