topic Moving through QVD data records in QlikView

Moving through QVD data records

Mon, 08 Feb 2010 12:44:38 GMT

Currently, I have a data source which has a list of exchange rates with an applicable data range. I need to turn this into a separate QVD with daily exchange rates.

To do this, I'm aware that I can use a Do loop in Qlikview and then do a LOAD for each of the source rates. Is there a command that would allow me to skip through records in the source QVD, e.g. a goto function or similar to the Recordnext (VB) command ?

Any help would be appreciated. Thanks

Moving through QVD data records

Mon, 08 Feb 2010 14:50:20 GMT

Hi, I'm sure to really understand, what you need to do, did you try to use the inter record functions :

that is to say :
exists, FieldIndex, FieldValue, peek, previous, lookup

You can also add a calculated field in your table using rowno() or recno() and then, use it for selecting required lines

Regards

Moving through QVD data records

rwunderlich — Mon, 08 Feb 2010 23:22:30 GMT

Look at IntervalMatch instead of uisng a loop. That is how this problem is typically approached.

-Rob