Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Generating dates and values from the last record

Hello, I am making a dashboard that contains some FX rates and documents so I linked the FX table to my data table via a key containing the date and base currency of the document. Problem is, I have the FX rates for the last working day. while some of my documents come in the weekend. This way I cannot access these documents.

The simplest solution that came in mind was to generate a date in the FX table a few days ahead with the same exchange rate as Friday(the last working day).

How can one do this in Qlikview?

Thanks in advance.

2 Replies
micheledenardi
Valued Contributor

Re: Generating dates and values from the last record

I think the following thread could contain the solution you're looking for:

Populate column with previous available value.

Re: Generating dates and values from the last record