Listing Data

[#1]

Hi,

I have created a table with information relating to dates, some of the fields are blank and I would like to populate them with the value directly proceeding it, I am not sure if this is possible as I am a novice to Qlikview,

Any help is greatly appreciated.

[fernandotoledo]

You can use the Previous() command, but only in a "load resident" statement with an order by clause.

Search for "Script inter record functions" for more!

Best regards,

Fernando

[#3]

Hi Fernando,

Thanks for that,

Regards,

[#4]

Hi Gene,

here are an working example. See the "Suplier" table for the script line you need.

Good luck!

Rainer